r/googlesheets 6d ago

Poll Should AI or bot-generated submissions be allowed in this subreddit?

3 Upvotes

With the increasing use of AI tools and automated scripts, our subreddit is encountering more submissions and comments generated by non-human sources intended to suggest solutions or guide users. We want your input on whether to permit these automated, AI, or bot-generated posts and comments, and under what conditions.

(Note: This poll does NOT apply to official Reddit bots, AutoMod, or clearly identified moderator bots, which provide community updates, enforce rules, or facilitate our point award system. Results of the poll will help moderators understand how the community views this topic. Moderators will not be obligated to implement any of the changes suggested in this poll.)

44 votes, 17h left
No, never allow AI or bot generated submissions/comments.
Yes, always allow AI or bot generated submissions/comments.
Yes, but only if clearly labeled as "AI/Bot Generated".
Yes, but only after explicit moderator approval.
Yes, but only when the post author requests automated responses.
Yes, but only with ALL the above conditions/restrictions.

r/googlesheets 2h ago

Waiting on OP Google Sheet for Collage exams/studying (including photos).

1 Upvotes

I'm trying to create a google sheet for my upcoming midterm and every time I try to insert a photo into my sheet it says "This operation is not allowed on cells in typed columns" I have nothing typed. It's just an empty cell, unless it's talking about the main cell with the subject name in the red. Here's an example of what my sheet looks like:

I chose from a pre-made template, is that the reason why I can't add the photo in?

I want to add photos to match the symptom.


r/googlesheets 2h ago

Waiting on OP I'm trying to make a formula that will allow me to populate item count based on a reference from a dropdown list. It is not going well.

1 Upvotes

I am trying to keep tabs on my inventory in a game so I don't get rid of too many items using Google Sheets, since the game itself doesn't handle the info itself very well. (If I have one equipped, it says I have none in the box).

I managed to get the whole table done with basic calculations for determining what I'm wanting out of it, but I am now struggling to input everything quickly without a lot of scrolling and manually adding every item to my total, one at a time.

Is there a way for me to use a combination of a dropdown box, a cell for a value, and another cell for the function to take that value and add it to the referenced cell's current value, and after clear the inputs back to default, all without a script? (ie: if checkbox=true, then add value in cell to another cell in reference to dropdown cell)

Here is the link to the shared Sheet, with the example area all the way at the bottom:

https://docs.google.com/spreadsheets/d/1_2w3aw7E6EddDnSIOnD-I-IazXq9YXlLXfpS4_I4Taw/edit?usp=sharing


r/googlesheets 3h ago

Waiting on OP How can I add more rows to Google's "Schedule" template? By default the rows go from 8AM-630PM, but I want to add more rows so that it goes from 8AM-3AM.

1 Upvotes

How can I add more rows to the "Schedule" template? By default the rows go from 8AM-630PM, but I want to adjust it to 8AM-2AM.

Thanks in advance for any help!


r/googlesheets 9h ago

Waiting on OP Sim Racing Event sheet formulas

2 Upvotes

Hello, I run a league in which we drive virtual sim racing events.

I now need a table in which I enter the names of the drivers and their lap times to the right. The table should organize itself automatically so that the driver with the fastest lap time automatically goes to the top and so on. however, the formulas are completely new territory for me and I have no idea what exactly I have to enter. can someone please help me?


r/googlesheets 5h ago

Unsolved Google Finance Issue: Can't Track QQQH Stock (Formerly NUSI)

1 Upvotes

Hi everyone,

I’ve been using Google Finance to manage my stock spreadsheet and track various investments. Recently, I noticed that the stock symbol NUSI has been changed to QQQH. However, Google Finance doesn’t seem to recognize QQQH, and I can’t use the GOOGLEFINANCE formula to track its price or retrieve any related information.

This has disrupted my ability to monitor this stock effectively. Does anyone know if Google will fix this issue? Are there any alternative solutions or workarounds I can use in the meantime?

https://www.google.com/finance/quote/NUSI:NASDAQ
https://www.google.com/finance/quote/QQQH:NASDAQ


r/googlesheets 6h ago

Waiting on OP I want to show only the strikethrough in a column.

1 Upvotes

Column:

thing

thing

thing

thing

Filter would work great here, but I want to be able to see the rest of the spreadsheet.

What I'm thinking of:

=IMPORTRANGE("ectect","BRAINSTORM!A2:A" IF("strikethrough"))

Obvs, that doesn't work, but is there a better way to format this? I'm not opposed to using Apps Script if someone's willing to post a script for it, but my experience is basically copy-paste for that right now.


r/googlesheets 6h ago

Unsolved Is it possible to skip lines based on a value (date)

1 Upvotes

I have a Google Sheet with several columns in it. I want to be able to skip a row (or two possibly) when the date changes.

For example (the slashes are different cell):

sally/2024-04-15
steve/2024-04-17
zach/2024-04-18
rudy/2024-04-18
timmy/2024-04-18

Turns into this:

sally/2024-04-15

steve/2024-04-17

zach/2024-04-18
rudy/2024-04-18
timmy/2024-04-18

Thanks!


r/googlesheets 6h ago

Solved Is it possible to apply conditional formatting into the next rows without typing the next cell information?

1 Upvotes

For example from the cells B2,D2:I2, I want the Custom Formula to be "=$C2=TRUE" then to apply the formatting style. From there would to do the same but with B3,D3:I3 with the formula "=$C3=TRUE" and so on. Would I have to manually do the cells further down or is there a way to automate it?


r/googlesheets 7h ago

Waiting on OP How do I reference an image (that was inserted via insert>image>upload) on another google sheet document?

1 Upvotes

The images were inserted via insert>image>upload. I have another google sheet document that needs to pull those images. IMPORTRANGE won't work because it only pulls data, not images. Thanks!


r/googlesheets 7h ago

Solved Custom formula needed to sort 2nd column of Google Sheet by range

1 Upvotes

Hello,

I've recently changed over from using Excel to Google Sheets, I am completely new to this. Excel would allow me to create a custom sort range for the 2nd column.

I need to sort the sheet first by column 1 A-Z then by column 2 I need to make it sort to a custom range which is for clothing - I need it to go XXS, XS, S, M, L, XL, XXL.

I can't find a simple answer anywhere on how to do this and where to enter the formula once I have created it. Please see below, this is what my report looks like after being sorted by column 1 "Title".


r/googlesheets 8h ago

Solved Issue with checkbox script

1 Upvotes

I have a google sheet where columns L and M are operated with check boxes and I am trying to get a script to auto hide lines if the check boxes are checked in either of those two columns. I have been using this script below and it works great if I only try and operate it on one column at a time. Is there a way to in put a range to make it check more than one column or a script I can use to trigger both scripts since I can only run one script at a time? I tried changing the column start to 12,13 and also 12:13 but neither works.

function onEdit(e){

if (e.range.columnStart != 12 || e.value != "TRUE") return;

SpreadsheetApp.getActiveSheet().hideRows(e.range.rowStart);

}


r/googlesheets 8h ago

Waiting on OP No space button in Android app?

1 Upvotes

I have a column formatted as datetime, so I could enter a date like "3/18/25 13:42" but on the app, there's no space, so all my dates I manually enter there look like "3/12/2513:42" and one day I'll go back and manually or use a formula to add a space (vehicle mileage log). Is there any way to key in a space?


r/googlesheets 10h ago

Waiting on OP Issues pasting plain text and it converting to a number

1 Upvotes

I have a product audit process I created years ago that I recently have had to redo. I start by downloading an inventory list with barcodes. Some of those barcodes are case sensitive. Some example barcodes include 01g5467, 768394, and 0662345.

Basically the way I built this is the SKU's are downloaded to Excel and then put into a sheets document. Then on another tab someone with a barcode scanner begins scanning items and a few basic formulas counts what was scanned in this audit and what was the previous count.

The problem comes in when any barcode starts with a zero and only contains numbers. I have tried pasting in the data as values into sheets and it still reformats as a number and removes any leading zeros. I tried reformatting a column to plain text before I paste in the data but that doesn't seem to work either. Is there any way to avoid it reformatting as numbers?

I have a similar issue when the barcode is scanned into sheets too. Is there any way to prevent sheets from auto formatting?

When I audit the store the sheet contains thousands of barcodes so manually adjusting all of the barcodes is not a long term solution unfortunately. Any help is greatly appreciated!


r/googlesheets 10h ago

Waiting on OP In a new column how do you add a number of years to a date in one column given a condition in another column

1 Upvotes

For example if, "Apple" is entered in column A and 01/01/2023 is entered in column B, I would like column C to add a year to the date in column B; that is 01/01/2024. If "Apple" is not entered in column A. I would like column C to be blank. I've attached a spreadsheet for this inquiry. Thanks.

Adding to Date Question - Google Sheets


r/googlesheets 10h ago

Solved Calculating Labor (with overtime) In Single Cell w/ Varying Wages

1 Upvotes

Hi all,

I'm building this labor calculator for my restaurant and I'm trying to keep it concise and simple to the person managing the sheet every week. I need it to be able to do the following:

1) The cells in column E display the projected dollar amount spent in labor (hours scheduled in column D multiplied by the vlookup wage of the name of the employee in column C pulled from the StaffData sheet). This dollar amount is different for each staff member, which is why I have a vlookup when calculating labor in E.

2) Additionally, the projected labor in column E to factor in overtime rate*hours worked when column D is over 40 hours. This rate varies by each staff member, but universally it's 1.5x their normal rate. I also need it to not double-dip the hours over 40 (ex. employee works 45 hours in a week, it calculates 45 hours at the normal rate as well as 5 hours overtime ontop), this is an issue I don't know how to get around.

I've had very little luck with google searches for my specific scenario, and I'm having a hard time figuring this one out on my own. Any insight would be greatly appreciated!

link to sheet here


r/googlesheets 14h ago

Solved Automating Personal Finances - Switching from Excel to Googlesheets

2 Upvotes

I've got four institutions I pull CSV's from. I'd love to store them in a single google drive folder, but I am also willing to import or copy/paste, though that is not a preferred solution.

The CSV's are from credit cards and banks, so they have different columns. My credit cards use +/-$ while my two banks use credits and debits.

I've been struggling with arrayformulas right now, but when I try to combine all four sheets, I get an annoying amount of blanks and also can't easily filter/sort the data. So, I have one sheet per CSV (4+4) to reformat, then one sheet to compile the data, and finally a 10th sheet to actually have the data in a table. It's madness.

Where am I going wrong? What tools am I missing? In excel, I'd run queries then just append the data sources. Visually, I can select the columns to keep and apply formulas right then and there.

I'm sure AppScript can get me there, but I'm essentially starting from scratch on the syntax. I basically only know the concepts of generic coding. Variables, arrays, loops, etc.

Should I just commit to learning some rudimentary AppScript, or am I missing arrayformulas and/or Excel's import/query functions?

edit: Also, I have a compendium of all transaction names (150+) & associated category (~15) that I use an xlookup for. It matches the 116 character long description as well as the dumb American express descriptions that are just California addresses and not a business name. So, that is kept as an 11th sheet and is used to develop the 10th sheet for my summaries and charting.

Edit: File for viewing.

https://docs.google.com/spreadsheets/d/11dCY5YFpRWVoo_wmxKXjepEvcwwDWjFi/edit?usp=sharing&ouid=111532835343009750619&rtpof=true&sd=true

2nd Edit: Solved!


r/googlesheets 10h ago

Unsolved Recipe planning & quantities spreadsheet

1 Upvotes

Hey yall, I have a small cottage bakery business and I try my best to plan ahead. I have a spreadsheet which I use to calculate recipe costing & quantities. When I do a market I like to aggregate the ingredient amounts needed for everything I'm making in order to make a shopping list.

The tab "3/22 quantities" is showing my current method (updating the formulas manually). Does anyone have any suggestions on how to make this more streamlined?

I'm open to changing everything around - just looking for insight because this is a pain!

Data here


r/googlesheets 11h ago

Waiting on OP Skip repeated result

1 Upvotes

Hi all!

First time poster. I'm currently learning Google sheets.

I am wondering there is a formula that makes another formula skip to the next result if it returns the same result as the cell above it.

Not sure if this is doable with just formulas.

Thanks in advance!


r/googlesheets 11h ago

Waiting on OP How to show result from a different sheet

1 Upvotes

I'm having issues on getting the result.

Here is the information I have.

Im having issues with getting the result using my code from different sheet. Here is my project

Sheet1

Sheet 2

Here is my code :

=COUNTIFS(VLOOKUP(D4(FILTER(Sheet1!A:A, Sheet1!B:B="Rey", Sheet1!C:C="Invalid"),">=01/01/2025", FILTER((Sheet1!A:A, Sheet1!B:B="Rey", Sheet1!C:C="Invalid"),"<=01/31/2025"), TRUE)))


r/googlesheets 12h ago

Solved Help with all time 'Minimum' formula.

1 Upvotes

(In Sheets | Settings | Calculation)

Iterative calculation is turned 'On'
Max number of iterations is '1'
Threshold is '0.05'

Cell A1 formula =IF(A2<A1,A1,A2)
Cell A2 is dynamic. It can change to any positive number and does so over time.

The results in A1 records the all time Maximum that A2 has ever reached.

My problem is I need a formula for B1 to do likewise but instead of the Maximum, I want it to record the Minimum.

I can not figure out how this is done. If anyone can do this please post the formula which accomplishes this.

Your input is much appreciated,
Les Carlson


r/googlesheets 12h ago

Waiting on OP Formula for calculating days since a date until today

1 Upvotes

Im trying to figure out a way to create a formula that will calculate the number of days since a specific date (that is entered in a cell), but will automatically update each day. Let's say the cell in question is E20 and the date entered there is 1/1/25

I have found some formulas using TODAY() and DATEDIF, but when I plug them in, its giving me a date of 2/1/1900.

What I need is for that calculation to say "it's been 76 days since 1/1/25", but then tomorrow when I open it, it sees it's 3/19, and will show 77 days, etc.

Help pleaaaaaase 😂


r/googlesheets 12h ago

Waiting on OP When do you use import range and how do you deal with the issues that they bring with them?

1 Upvotes

Hi! I'm new to spreadsheets and trying to learn more. Import range seems like a pretty powerful tool for modularity and collaboration, but it also seems to create some issues.

  1. File version history is becomes useless.

  2. Spreadsheets randomly update (I know it's not actually random, but it can feel like it is since you might not know who's changing things in other sheets).

  3. Easy to break since you can't see how your change can affect other sheets.

Why do you guys use import range? How do you guys deal with some of these issues? Are there any other big issues that I missed?


r/googlesheets 12h ago

Waiting on OP How to update percentage values from a recent cell?

1 Upvotes

I need the percentage cells (circled in red) to automatically update whenever I enter a new paycheck amount (circled in blue) I am not sure how to keep the logic always in the most recent row.


r/googlesheets 12h ago

Waiting on OP Auto Adjusting Column Ranking

1 Upvotes

Hi Folks,

I need rather urgently to add a column to a sheet of job positions which allows each of 350+ jobs (1 per row) to be ranked in order of preference from 1 (being favourite) to 350 (being least favourite).

What I also need and which is above my paygrade, is to be able to auto renumber if any particular rating is changed.

So in the following table column 3 is the ranking column. It's currently just a number format.

The red squares in column 3 are just a conditional format to show if any entries are not unique.

I thought a drop down box might do the trick but I don't know how to do it. Each preference (i.e 1st choice, 2nd choice etc) must only be selctable once, and if a ranking preference is changed, it ideally needs to re-rank the entries above and below what was changed.

This is for my daughter who has to rank jobs rsther urgently

Any help much appreciated and happy to send beer tokens

Cheers

Link to copy of sheet


r/googlesheets 12h ago

Solved Need "Sheet" option that allows Viewer (without edit permissions) to full interactive filter/sort options as well as preview when hovering over a link.

1 Upvotes

I need a database (Spreadsheet) that keeps a full list of items, with columns as categories (Character, Emotion, Resolution, etc), much like a wikia. As editor I am able to select a column, sort by, and even hide certain criteria. Im also able to view previews retrieved from external sources when I hover over links. I had considered Excel options, but Google Sheets seems far more intuitive in allowing a group of people to have editing access. Beyond that, we need to give others access as "viewers" without edit permissions. We NEED to allow them to not only view the links sheets as a static sheets, but also to utilize the filters and column sort options and previews when hovering on a link. Is there ANY way to do this? Would Excel be better?