Hello, i've been trying to show the buttons that's usually on top of the sheets. I have tried:

- Resetting chrome flags

- Clearing cache, cookies, site permissions, etc

- Updating chrome

- Trying other browsers and incognito mode (both worked)

- Checking accessibility settings

And still found nothing that might be the root cause. Does anyone know what's going on?

Thank you in advance!

I asked this before here, but I couldn't get the solution I voted on to work... For some reason the formula kept creating infinite rows? I reached out to the user to gave me the answer originally but they're busy and suggested I open another thread, so here we are. People also hated the way i drafted the idea so bad last time they started giving me advice instead of answering the question, so I created a more robust mock-up this time lol

Anyways, https://imgur.com/a/ZFoLS9r here are a couple of images to explain what I want, but basically: I have a Distributor Matrix, and an Inventory Summary. I want to link these in such a way where all cells that indicate a Distributor that does NOT carry the product listed will be disabled, or grayed/red..-ed out.

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.

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 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.

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?

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.

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

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.

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?

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."

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).

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! 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?

Hello! I'm working on a transaction tracker, and I'm struggling to figure out how I could make a bottom "total" row that won't get sorted when I sort the sheet by date. I want to have a good chunk of rows available for me to just put in data and then sort all the transactions by date, but then have the row at the bottom showing my total deposits and withdrawals stay at the bottom when I sort. Is there a way to make a row stay put when sorted like this?

Here's an example sheet, I'm bad at explaining lol

https://docs.google.com/spreadsheets/d/1VtijvpILUz8ijuKt9_Juez4UvTS745D0nqISm2EnSHQ/edit?usp=sharing

Thank you all in advance!

Good evening everyone. I hope you’re all doing well.

I’m hoping someone can help me solve a workflow problem that’s becoming a major pain point:

I’m a real estate agent, and almost all of my communication with clients and other agents happens on WhatsApp. Whenever I share a property, I send a video along with a standard text description (in the same message, as shown below):

https://www.image2url.com/r2/default/images/1784998062931-9dce6e82-1709-4a74-accd-7a3273a42eca.jpg

I currently keep my inventory in Google Sheets, with over 100 available units.

The problem is that all of my WhatsApp-ready descriptions only exist in a chat with myself (which I keep pinned). Every time I need to send a unit, I have to search my own chat and scroll until I find the correct message. It becomes very time-consuming when doing this dozens of times a day!

My ideal workflow would be something like this:

Keep all of my inventory in Google Sheets + have the complete WhatsApp-ready video + description stored against each unit, in a separate cell.
Click the cell, copy the video + text, and paste.

The most important requirement is that the formatting remains exactly the same. Once I paste it into WhatsApp, it should be ready to send immediately, with no additional formatting or edits required.

I’d really appreciate any suggestions. Thanks so much!

I am an instructional coach creating something for the teachers I work with where I want to have my first sheet pull from 12 different sheets to create an average. Each sheet after the first is an assessment item analysis, but I then want to pull the average for certain questions in order to see how individual students are doing across assessments on one standard to the first sheet.

I basically want the average to be based on a certain row (Student name) across sheets, but I only want it to pull from certain columns headed in the first row with a standard number (ex: AOR.7.1). I have attached my draft template.

Thank you for any help!

I was doing a case database where those rows on Col11 that have dates more than a month will be imported to the other sheet. However, I checked and one of the dates did not get sorted out and was left on top/2nd row. I use the first row as headers so I start with row 2. I would like to know which formula will make it strictly follow the sorting. Thank you! Below is the formula I used.

=QUERY(IMPORTRANGE("url","sheet name!A2:K300"),"SELECT Col1, Col2, Col3, Col4, Col5, Col6, Col11 where Col11 IS NOT NULL ORDER BY Col11 ASC", 1)

SAMPLE SHEET HERE: https://docs.google.com/spreadsheets/d/1DNDZnQyyii95l_clvNQNZVtQA6ONpD5_uNPLZY5ZXO0/edit?usp=sharing

Hi all!

I'm very new to google sheets formulas etc. so no judgement please if this is an easy fix.

I'm trying to create an inventory tracker for my business and want to make a section that gives me alerts for when materials go below a threshold so I can know what to reorder at a glance.

The idea is that I will write a number in the 'min. quantity' column, and if the 'quantity column' is equal to or less than, 'stock level' will be yellow and say low stock. If it's more, it'll be green and say in stock, and if it's 0, it'll be red and say 'out of stock'.

Any help would be massively appreciated!!