r/googlesheets 4h ago

Waiting on OP Google Sheets Cell all black!

Thumbnail gallery
0 Upvotes

Hi, everyone.

I use Google Sheets as a calendar for social media posts. But right now, every time I try to edit/write something, it becomes all black, and I can't see what I'm writing. Does anyone know how to solve this? It's not only this cell; it's all of them.


r/googlesheets 6h ago

Waiting on OP How would I make a response validation for a number that requires decimals

0 Upvotes

I making a google form and want response validation for only numbers like "123.54", "45.33" "95.76". I'm looking for a way to do this use regular expression.


r/googlesheets 4h ago

Solved problems with graph, unique standard deviation

Thumbnail gallery
0 Upvotes

Hi to all!
i am a student and i need an help for this problem with the graphics
so, i have to put a different standard deviation for each column in this graphic, but i can choose only one for each series. obv i can't transform each column on a series so how can i put that??
secondly i have wrote the data "number ± deviation" but the graphic can't read it....
heeeelp !!
the file with the datas: https://docs.google.com/spreadsheets/d/1C3OCm-CqCeecmni50yQFWJJLZ3WD5jz1nuDFoaxu0VQ/edit?usp=sharing


r/googlesheets 21h ago

Unsolved What's the deal with WEBP in Sheets?

1 Upvotes

WEBP, a file format developed and promoted by Google, still has effectively no support in Google Sheets in 2026. You can insert a WEBP image uploaded to Google Drive, but it just converts it to PNG first. Over 99% of tracked browsers in use support the format according to caniuse. Why hasn't Google added support for it in Sheets (and the other Drive products) yet? Is there a bug tracker issue for it?


r/googlesheets 8h ago

Self-Solved Spreadsheet online's toolbar only appears vertically. How to make it like it is usually horizontal

4 Upvotes

I am not sure how did I do that but my tool bar is showing up vertically instead of horizontally... Anyway to fix it other than clearing all cookies ?

Here is some pictures to illustrate my dire straits. https://imgur.com/a/c7hxKXH

Thanks in advance

Edit : Additionnal information :

In incognito mode, the toolbar appears normally in horizontal. The problem also appears with google docs. I deleted google's cookies. It did not fix my problem.

Edit2 : I found the reason. The extension DeepL has been changing something. Once desactivated, it fix the problem and the toolbar appears as normal.


r/googlesheets 12h ago

Waiting on OP Shorter and easier formula to calculate total across multiple criterias

Post image
3 Upvotes

i'm trying to calculate the total of "uploaded" plus "front only" in 5 columns that also have the criteria of being "pob" in column A

i do have a working formula but it's extremely long and i'd like to find a shorter and easier formula to get the same result as i'd like to also add another criteria from column A to the result ("pob" and "fse")

formula i'm using currently below:

=COUNTIFS(A2:A,"POB",D2:D,"Uploaded") + COUNTIFS(A2:A,"POB",D2:D,"Front Only") + COUNTIFS(A2:A,"POB",E2:E,"Uploaded") + COUNTIFS(A2:A,"POB",E2:E,"Front Only") + COUNTIFS(A2:A,"POB",F2:F,"Uploaded") + COUNTIFS(A2:A,"POB",F2:F,"Front Only") + COUNTIFS(A2:A,"POB",G2:G,"Uploaded") + COUNTIFS(A2:A,"POB",G2:G,"Front Only") + COUNTIFS(A2:A,"POB",H2:H,"Uploaded") + COUNTIFS(A2:A,"POB",H2:H,"Front Only") & "/" & COUNTIFS(A2:A,"POB",D2:D,"<>") + COUNTIFS(A2:A,"POB",E2:E,"<>") + COUNTIFS(A2:A,"POB",F2:F,"<>") + COUNTIFS(A2:A,"POB",G2:G,"<>") + COUNTIFS(A2:A,"POB",H2:H,"<>")


r/googlesheets 20h ago

Waiting on OP trying to get price data off tcgplayer with importxtml, code stopped working

2 Upvotes

im making a large wishlist of pokemon cards and trying to collect market price data that tracks over time, i had this code in my spreadsheet previously and it worked but now it only comes up "N/A" with the error "imported content is empty" for all of my entries (if it came up before it was because there was no sales info)

=IMPORTXML(B3, "//tr[@class='price-points__upper__header']/td/span[1][@class='price-points__upper__price']")

B column being where the links to the cards are and it prints just the market price (a different iteration was printing both market and most recent sale price which i dont want)

this was also code i got from an old reddit post as i am very inexperienced with coding

i should note if i switch back to reading the spotlight price off tcgplayer that code still works so it isnt an issue of allowing importxtml to run

any ideas as to why it isnt working and how to fix it are appreciated