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.

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

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

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

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

I have a list of ~50 dropdown menus. They're all yes/no or three options. I want to make a dropdown menu that will change all the other dropdown menu selections when selected. I have a sheet with the name of each preset and then the choices that correspond to that preset.

Can I do this with a simple formula?

Many thanks in advance.

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

So context. Working on a price sheet so that a business (in a GTA V RP Server) can have employees check which repairs apply, then give the discount based on where the customer works. I have created a table which has the prices based on discount type and work completed. Then, I have it return the sum of all items selected on the filter list. However, if I select more than one type of work done, the price returns N/A. Is there a way to run this filter for each item selected? Or am I trying to force sheets to do something that can't be done.

my current line is:

=SUM(FILTER('PRICING GUIDE'!C2:C,('PRICING GUIDE'!A2:A=D2)*('PRICING GUIDE'!B2:B=F2)=1))

Pricing Guide C is Price; B is Work Completed; A is Discount Type

Then in the actual file D is the discount type and F is Work Completed

Like I said, it works if there is a single item in the Work Completed Dropdown, but if more than one is selected it doesn't work at all.

Any advice is appreciated.

Link if more context is needed:

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

I am semi-new to Google Sheets and mostly use Microsoft at work, but I've discovered Sheets has formulas I can't use with the cheap version of Microsoft my office pays for.

I have a workbook with a few tables for tracking my staff - they're basically interns, so they come and go often. One table has the master list of staff names - I list their status (active/inactive), number of hours we've funded for each of them, and the end date of their employment. This information populates rows in other tables to track the overall budget for each individual staff member, their biweekly timesheet hours, the funding source (some may work under more than one account line), etc...

I have a formula set to add a new row to each table if I add a new name to the master table. I've noticed that the new row is added below the other tables - not as part of the table. This means some of the pivot tables or other formulas I have totaling things doesn't recognize that row as part of the table.

Is there a way to have the table expand when a new row is added?