r/googlesheets

My google form has questions of the "checkbox" type with several options including commas. The problem is: when they're exported to a linked google sheet, the comma is also used to separate each option. This makes it a nightmare to parse afterwards since comma means two different things. And yeah, I could use a hyphen in my question options but it's not ideal as it doesn't look professional. I'd rather just make google sheets use a different character (ANYTHING else would be better than a comma).

Is it at all possible?

Edit: to provide an example, my form is about activities people perform at work, and some of the options I provide include commas. The form is in Spanish, but think of options like "organize paperwork, documents or client submissions" or "grade exams, academic work or overall performance". So whenever I get this exported it ends up in a single cell containing "organize paperwork, documents or client submissions, grade exams, academic work or overall performance" (without the quotes).

I want to set it so that if A1 and B1 both have a "Y", they both change colour. "Is equal to" does this with numbers but not letters. I do not know how sheets works! This is to track progress in a game.

Hello all!

I am relatively new to Excel/Google Sheets and am wanting to do a little "automating" for my job that makes it easier for me to spot due dates and potential due dates. My overall goal is to have cells be highlighted at certain colours when they hit certain time intervals past a date in a cell. For example; if I have E63 at a certain date, I want to be able to have E63 turn green after 7 days has passed since that date (05/19/2026), orange after 12 days, and red after 14 days. I would only be doing this to the dates that are on the furthest part of each row. Nothing before that row.

I have already tried to google and Youtube this answer and any custom formula I try just is not seem to be working. I am thinking that either the initials that are in the cell are causing the screwup, or I am not formatting the dates right.

https://docs.google.com/spreadsheets/d/1qjl46vQzgi_Vw3yMrgUsVoOm6tO-wtg2/edit?usp=sharing&ouid=104042642632983553883&rtpof=true&sd=true This is the link to the original spreadsheet!

My formulas I am using here are:

=E63>=Today()+7, =E63>=Today()+12, =E63>=Today()+14

Any thoughts would be appreciated!

P.S Maybe =NOW()>E63+7 would work?

https://preview.redd.it/f8s06jjsti2h1.png?width=1008&format=png&auto=webp&s=800bf13e4212704d59e693dede30152015f48f72

Thank you to @HolyBonobos for the help already!

I'm using Sheets to track my worked hours, and trying to use a formula to list the dates rather than enter manually.

I work 6 days a week and skip Sundays, so I have the sheet split into blocks of 6 rows (days), with a blank row in between to act as a visual spacer.

I tried using ;

=SEQUENCE(7,1,DATE(2026,5,25),1)

But that fills all 7 days of the week, ignoring the blank row and putting Sunday's date on it.

That would be fine, but I'd really like to keep that blank row as a visual spacer.

I am creating a Google Sheets spreadsheet to keep track of my expenses.

My bank provides me with a CSV file that includes data such as Date, Expense value, Details

So examples would be:

2026-05-20 | $50.00 | Pizza Hut
2026-05-21 | $39.95 | Netflix
2026-05-22 | $49.50 | Local hairdresser
2026-05-23 | $19.45 | McDonalds
2026-05-24 | $40.00 | Pizza Hut

I would like to add a 'category' colum to this spreadsheet. That includes broad categories such as 'Dining out', 'Groceries', 'Streaming services', etc.

There are plenty of businesses that I regularly spend money at. I would like a way to autofill this Category column based on the name that appears in the Details column. e.g. a way to know that if the Details column has 'Pizza Hut' or 'McDonalds', to add a value saying "Dining out' into the category column.

Can someone please suggest a way to do this in Google Sheets?

Hello,

I have column A, where I can input any number from 1 to 200+.

I need column B to display a "3" if A is 1 thru 15.

Display a "6" if A is 16 thru 40.

Display a "10" if A is 41 thru 80.

And display a 15 if A is 81 thru 140.

I hope I described this well enough to understand what I'm trying to get help with.

Thanks in advance!

Hi all, can't quite figure out what is happening, maybe conditional formatting doesn't accept formulas like this?

In my sheet, I'm trying to highlight specific rows if one of their cells contains the word "loaned". We have items we are tracking, some are bought, loaned, etc. It's super important we know what was loaned as we have to return it in it's original condition.

I'm using this formula =ISNUMBER(SEARCH("LOANED",$J57)) applied to the range A5:L120

If any cell in A5:L120 contains the word "loaned" then make the row of that cell highlighted red.

I used the identifier $ in $J57 to indicate that this search applies to all of column J not just J57.

I tried the following:

- Applying the formula only to row 57 to see if there was an issue with searching within the larger range.

- Removing the $ identifier incase that caused a circular formula.

- I tried applying the formula as an array formula: =ARRAY(ISNUMBER(SEARCH("LOANED",$J57)))

- I tried only using ISNUMBER and SEARCH formulas.

What am I missing? Any help is appreciated <3

I have a column of cells, and each cell is an equation that computes a value based on values in the row. Then the column is formatted as percentages.

So it looks like a column of percentages. It's column Q.

I am just trying to highlight everything in green in column Q that is less than or equal to Q9. I am using conditional formatting, and I can't get it to work.

I've tried the less than or equal to. It doesn't work. I've tried custom formula with =Q3<=$Q$9. Doesn't work. I tried random things that Google Gemini is telling me, like =AND(ISNUMBER(Q3), Q3<=$Q$9), and it doesn't work.

(If anyone from Google is reading this: Google Sheets is so bad that you should be embarrassed to say that you work at Google just because of Google Sheets. Just copy Excel, please.)

I want to just work on one tab the whole time. But i'd like to have a dropdown menu that allows me to organize each row onto different tabs automatically. Is that possible?

Thank you!

Is there a way to use the drop down on Column A and automatically have it added onto the different tabs on the bottom?

I am using Excel and every time I write in a cell it just goes in one singular long line as opposed to wrapping and becoming like in paragraph form. How do I make the sales tax wrap and make the text go down vertically as a as opposed to a cross horizontally I’m using Google sheets not Excel. Sorry thank you for your help.

I want to create pivot tables that compare survey responses (rows) across age groups (columns). My age data is currently in single years (e.g., 11, 12, 13), but I'd like to combine them into a group (e.g., 11-13)

Is there a way of combining the ages into a single column in Google Sheets?

Thanks.

How can I correct my formula so that my Uniqe list doesn't merge cells across multiple columns on a single row?

https://preview.redd.it/56ltiluqa92h1.png?width=2824&format=png&auto=webp&s=1000da81085c2d44d80309d610fec46edf7d5708

https://preview.redd.it/mcb0d29ra92h1.png?width=1492&format=png&auto=webp&s=0740c4f4cce4b654360559825e8c5dcebdd19132

https://preview.redd.it/8buvrnpra92h1.png?width=755&format=png&auto=webp&s=533e3b399b1114ff5e7cc87ac3c9a33499a5d46b

Hello all.

I'm hoping someone here can help me because I'm at my wit's end. Long story short, I created and maintain (keep running) a spreadsheet for work that we use to track our service/breakdown department's performance and SLA compliance. Rather than scroll all the way to the bottom of the sheet and manually drag formulae into the new row, I've created a script that inserts a new row and enters the formulae into the top of the sheet. I have the code entering the formulae, instead of copying it, because it works faster than having a script that copy-pastes only the formula into the new row. And my script works a treat, EXCEPT for whatever is happening in column O.

When I remove the code for O, it works just fine. But with the code for column O included it has a shart attack and won't proceed. I've tried moving the data in O to L and the same thing happens. The script works fine until it has to process THAT particular column, then it just stops. Again, removing O from the code makes it work 100%. The code for O and H is almost identical and for all intents and purposes it is, the maths in the formula is a little different is all. I have tried many different versions and functions but the result is the same. It stops at O. I have even tested O with using the SAME EXACT CODE from another work column and it still will not work.

Oddly enough though, a script that simply copy-pastes row 6 into the newly inserted row 5 WILL copy column O, but also all the manually entered data as well which I don't want.

I think I've explained myself well enough. Please ask any questions you may have. My script is below.

https://preview.redd.it/arebqazj972h1.png?width=1181&format=png&auto=webp&s=f3b2e0b2f9af4f11f9f0834f4b234eda2ac5a88f

https://preview.redd.it/7hcj6zxu082h1.png?width=170&format=png&auto=webp&s=02515be8fa4471298de2f63e9cfab6d69d545708

Trying to assign conditional formating to any row marked "Group" ("E") by using the row number of the group's first appearance as a stable identifier (D).

I attempted this:

=AND($E2="Group", COUNTIF($D$2:$D$600, $D2)>1, MOD(COUNTUNIQUE($D$2:INDEX($D$2:$D$600, MATCH($D2, $D$2:$D$600, 0))), 4)=1)


=AND($E2="Group", COUNTIF($D$2:$D$600, $D2)>1, MOD(COUNTUNIQUE($D$2:INDEX($D$2:$D$600, MATCH($D2, $D$2:$D$600, 0))), 4)=2)


=AND($E2="Group", COUNTIF($D$2:$D$600, $D2)>1, MOD(COUNTUNIQUE($D$2:INDEX($D$2:$D$600, MATCH($D2, $D$2:$D$600, 0))), 4)=3)


=AND($E2="Group", COUNTIF($D$2:$D$600, $D2)>1, MOD(COUNTUNIQUE($D$2:INDEX($D$2:$D$600, MATCH($D2, $D$2:$D$600, 0))), 4)=0)

However it returns a result where rows with different D values (202 and 304) are formatted the same. Any suggestions on what I'm missing?

https://preview.redd.it/p9gefa86182h1.png?width=186&format=png&auto=webp&s=c00a15d2a25aa62556bade1e57464df7e51b8108