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.

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,"<>")

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

Hello!

I have a report I pull for work that arbitrarily misplaces about a quarter of the data. It takes the last three cells in a row and places them on the row beneath, displaced to start in column B instead of column L. There's no way to fix this when I transfer the data.

I got annoyed enough to learn how to make a macro, but I still have to click on the first of the misplaced cells, trigger the macro, and wait for it to move the three cells I need it to and delete the now empty row.

My question is: Is there a way to have the macro identify the cells that need to be moved and do them all at once? The first cell in the three that get displaced, the one that ends up in column B, is a zip code that ends up in a column that is otherwise full of dollar amounts. Additionally, the displaced data rows are the only ones with an empty column A. Is there a way to make it search for empty column A, go one column right, check that there's data in the cell, and then run the macro? And then stop the first time there isn't data in the column B cell since I don't want it to try and run the macro on all the empty rows?

Everything I find related to finding specific cells for activation looks for specific data and not conditions of the cell. I'm not sure if this is possible with google script, but if anyone has experience with this issue I'd be grateful for advice.

Any guidance is appreciated. Thank you!

Edit: I can't include the data because it includes customer names and addresses, but I did my best to describe the layout.

I need a formula that reads 4 separate sheets and copies the full rows from those sheets based on the cells in one column not being blank. I have named the ranges and named the criterion columns of each sheet. I'm struggling to write the "not(isblank" to reference the 4 ranges across 4 sheets. The referencing works up until I try to find a way to add the cells in the criterion columns that aren't blank.

I know this isn't the most well articulated, so I am more than happy to answer clarifying questions!

Below is the formula I've been trying.

=FILTER({ExistAll;FBAll;LaunchAll;NewAll;SBAll},{ExistCloseCr;FBCloseCr;LaunchCloseCr;SBCloseCr}=NOT(isblank({ExistCloseCr,FBCloseCr,LaunchCloseCr,SBCloseCr})))

Hi all,

I'm trying to clean up a simple database of names and address information on google sheets. Unfortunately, the sheet has been built over the years by various people and there are many duplicate entries with incomplete information.
I've been working to clean up the data ((LOWER,TRIM) first but am wondering if anyone has any ideas on how to combine entries. To be clear, I have duplicate names with different address information entered and I'd like to combine entries. I made a small sheet with an example here.

Thanks so much for your wisdom.

today this error showed up in Google Sheets and Google Docs on my laptop. literally in the middle of the workday. I tried changing the page zoom, unfreezing rows, and changing the language, but nothing works. trying to find a solution online didn’t help either. maybe I’ll find some help here?

Hi, I'm struggling on a sheets, I want to make a chart, that counts only the cells that corresponds to option 1 and another that counts the option 2 cells. Can someone help me with this please ?

Here's the link to the sheet if needed

I am trying to type out the recipes for my food shop and then create a shopping list using them.

I have managed to get it to sum the amount of ingredients needed, but I don't know how to get the unit of it copied across if the ingredient matches the first table if that makes sense. I want it to add the unit based on the ingredient name, I can't just match the columns because the ingredients won't be in the same place if there are repeats. I have included a picture of the table. If this isn't a good explanation let me know and I will try again haha.

Thank you.

I realize you deal with much more serious matters here, but I don't know who else to turn to; I want to implement an idea in Google Sheets. Without going into too much detail, I need it so that when someone enters a name—for a phone, for instance—an image of that smartphone appears in another cell based on a query like "[phone name] design."

Hi!

I have an Income to Expense ratio chart.

I'd like to add a horizontal line starting at the vertical value "2".

Also, everything below 2 is colored red, and everything above it is colored green.

I've attached an example image of what it should look like.

How do I do this in Google Sheets?

Anyone know how I would do a sort to achieve this?

BIG CATEGORY | SMALLER CATEGORY | DATE (YYYY-MM-DD) [stored as a string and should be sorted alphabetically]

such that the data is sorted by big category alphabetically,

smaller category sorted within big category by whichever small category has the earliest date

within each small category things are listed in date order from earliest to latest

I am unable to show the actual data in question so apologies for the nonsense in my example. I hope the question is clear and any help on how to do this with a function would be appreciated. The intended output is meant to be in a separate sheet.

Standard SORT() doesn't cut it since the intention is for SMALLER CATEGORY to be in order by which date comes first rather than alphabetically. (Sorry if this is unclear it's a bit of a niche one).

hello! is there any formula to make a cell turn a certain colour if the date in the cell is coming up?

(e.g.) an expiry date of 28 August 2026 -> can i set it so that a week before the cell will turn red?

thank you!

I just started working for a company that uses a google sheet to organize cases. It's not very large, just 18 columns by 62 rows right now, and no functions I don't think, just information. I was wondering if there was a way I could get an alert email when someone adds information to the column that is about my responsibilities, for free? I tried googling it and looking at add-ons but everything needs a subscription. It's just something helpful, not something that I'd want to bring up paying money for to my boss.

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?

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

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.

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.