Login

r/googlesheets

Can't access sheets or docs on chrome, a way to fix would be great?
▲ 1 r/googlesheets

Can't access sheets or docs on chrome, a way to fix would be great?

I have tried:
- Clearing cookies and caches (all-time - selected everything)
- Signed out and back in

- turned off extension and back on, even removed it and then added it.
- Incognito Mode wont even load sheets/docs

- watched 3 videos and none have helped.

This all came out of nowhere and haven't done anything new, haven't downloaded anything, and haven't been on any schetchy sites.

u/Acevecchio — 8 hours ago
▲ 37 r/googlesheets

Google sheets randomly deleted

So today I had two sheets I had been working on for a very long time randomly disappear, when I click on the link I get this image. Idk what could have caused this, I own both documents. They both were copper off something else but I don’t see how that would have mattered. I can’t find them in my trash either.

u/Minimum-Courage1039 — 3 days ago
▲ 1 r/googlesheets

Autopopulating third column that combines two text columns

I am trying to get tasks sorted by importance/urgency (the Eisenhower method).

Here's what I'm trying to get done.

Id like to create a formula that will autopopulate column F.

Column D options are highly, somewhat, not important, and E options are highly, somewhat, and not urgent.

That leaves 9 possible options for column F:

highly important, highly urgent,

Somewhat important, highly urgent

Not important, highly urgent

Highly important, somewhat urgent

Somewhat important, somewhat urgent..

You get the idea.

The formula reads column D and E and combines them to populate F automatically.

I figure this might be in the line of a "if then" type thing but I haven't figured how to combine them to output to one cell.

u/DarkArctic88 — 23 hours ago
▲ 8 r/googlesheets

Formula with 3 variables?

Hi! So I’m really struggling with creating a formula that has three variables. I have tried many different variations of =IF and =IFS but none of them seem to work and I always get some kind of error. What am I doing wrong? I need it to include if D22 < E22 , R8

u/Past-Watercress-5556 — 1 day ago
▲ 1 r/googlesheets

Formula for calculating variable percentage fees

I am trying to create a formula around some new eBay fees, which changed from a fixed percentage to variable percentage depending on value. This sort of thing is completely new to me so have no idea how to tackle it.

I am using $50 as an example, Ideally, I would like to be able to

  1. Enter a number, and get the final amount buyer pays (since they pay the fee) eg. I enter $50 in one cell and result is $53.70 in another cell.
  2. Enter the number to see the inverse, eg I want buyer to pay $50, and I see what amount I need to list it at to appear as ($46.51)

The rates are

  • $0.30 per item
  • 8% of the item price up to AU $20, and
  • 6% of any portion of the item price from $20 to $500, and
  • 4% of any portion of the item price from $500 to $5,000

Any tips on how to achieve this would be greatly appreciated

reddit.com
u/PhilGooodInc — 2 days ago
▲ 1 r/googlesheets

Display full HQ images in google sheets.

Hello,

Context :
I'm trying to display an image (241ko 1000x829) (yes it's hots Alterac Pass ma nerds) on its full quality. I don't care how deep I need to go, it has to be done.

I've tried :
- Reducing weight file, dimensions, but it just won't work properly, work properly as displaying the image in its original quality.
- If I cut the image in 4, to reduce weight and dimensions drastically, the images are displayed at their real quality, which is nice, but I got those white borders from the Spreadsheet file.
- Looking for ways to bypass the weight restrictions but never found anything, people say hosting the image via =IMAGE("URL";..) is the best way. But sadly I've been doing that since the very beginning, never thought it'd be possible to display an image without this formula.
- I've tried the same formula on a new file, just to know if there was any weight limit reached on the main file, but I have the same result. Even tried on another account with 95% of free space on G account.
- I've tried to switch the format from JPG to PNG but it didn't work, lol PNG weight like 6 times more than JPG.. Originally, the images were in webp, which I believe is even lighter, and it didn't work either.

At this stage, I'm really hoping I'm dumb and I didn't see something obvious, pleeeeaaaase 😃

u/KourtGamingShow — 8 hours ago
▲ 0 r/googlesheets

Help with Google Books API

I want to start by clarifying that I am in over my head. 

I work with a small, poor church in Africa that has just received some books for it's first library. This is incredibly exciting! However, our team would like to have a way to keep track of the books and we are using a google sheet to put in ISBN's and then auto-filling the rest of the data through Google's Book API. 

The problem I'm having is that I am getting a 503 error almost every time I use it. Occasionally It'll pull 1 or 2 books, but then the error comes up. The code that I'm using is a few years old, so I assume that's where the issue is. I'm willing to share my sheet or the coding that is in it for help, but I'm also not sure if it's something on the API backend that I may not know about as well. 

Here is a link to the form: https://docs.google.com/spreadsheets/d/1DqpU0ATnK4GTiV2RNzvBt5fAcE_VMcBt5Kqf65jzkAI/edit?usp=sharing

The 2nd tab has a spot to put in your Google API code, which I've deleted as I'm sure that shouldn't be shared wiley-niley.

I asked about this on the Google Sheets help forum, and had someone attempt to help me, but he wants me to input code into the code, and after trying to do that, it completely broke. I find Reddit to be friendlier than the Google forums, so I'm coming here hoping for some help.

u/SnipedintheHead — 1 day ago
▲ 1 r/googlesheets

Difficulty with Greater than or less than on Google Sheets

How do i do this?? im not on google sheets much, but i wanted to do something like this

=if(AND(I2:I18<500),I2:I18/0.03)

explained:
if any cell in this row is less than 500, then multiply it by 0.03
and then somehow get the sum of all of them put together at the end in this box

EDIT:
this has been fixed, however i was wondering what to do if i wanted to do the same for a value in between 500 and 2500?

reddit.com
u/vortex_homy — 1 day ago
▲ 1 r/googlesheets

Player Point drafting system

Hello!

I'm trying to create a sheet with a list of players they can draft with their own point value from players that cost 1-7 Points.

The idea is that each captain has 16 points to spend to make their team and I want it to also show how much points they have left to spend

For example: Team Captain A wants someone from the 6 Point category so once I placed that person in his team it should deduct points totaling to 10 points remaining.

Heres a copy of the sheet im trying to do https://docs.google.com/spreadsheets/d/1UhnuaPO4eTfwCrGCA1nwQnOk8_PZjNGCxGDoAqg1jfA/edit?usp=sharing

u/LuckyUnluckyLP — 5 hours ago
▲ 1 r/googlesheets

SUMIF and SUMIFS formulas not updating

I created a budgeting sheet in April which worked fine all of last month, and now I've copied it for May and initially this copy was also working. However, a few days ago I noticed that formulas showing the total amount spent, using SUMIF and SUMIFS, aren't updating any more.

Everything that should be numerical data has been formatted as such. Additionally, from the Settings I've made sure Iterative calculation is off, and the recalculation setting is set to "On change and every minute". I've also tried creating a new file and copying the contents of the original manually there, and still it doesn't work. Any ideas?

Formula for mandatory expenses (\"Pakollinen\")

Formula for extra expenses (\"Ylimääräinen\")

These are the other two tables referenced in those formulas

reddit.com
u/Illustrious-Fee1784 — 3 days ago
▲ 2 r/googlesheets

ROUNDUP function....

Hi, at the moment the cost of a bet (sports betting) depends on it's price, for example, if 2/1 (or $2.50 in decimel), and I want to win $300 per winning bet, the formula is =300(A1-1)

How can this be modified to automatically round up to the next 10?

For tidyness, I want the cell to be empty if A1 is empty

Many thanks

reddit.com
u/theycallmeLL — 1 day ago
▲ 1 r/googlesheets

Oddly Specific error of a letter disapperaing

I have a spreadsheet that has an extremely specific error on it. It only happens on cells A6 and A7. And it happens on every sheet.

When I type anything that starts with"Be" into those two cells, the "e" is invisible. Bear becomes B ar, Bee becomes B e. This doesn't happen if I type Fear or Fee. Or Block or barn. If I copy what is in A6 and paste into a different cell, the missing "E" returns. And if I copy and paste into A6, the "E" still shows. It is only when I specifically type a word beginning with Be into one of those two cells.

What on earth could cause this and how can I fix it?

reddit.com
u/JayR17 — 1 day ago
▲ 0 r/googlesheets

Query sheets using multiple Cells as query reference

I have a query that searches multiple sheets for matches based on your input. The problem is i keep adding more sheets which means i have to update the query when i add one

Would it be possible to use a column on a sheet that lists all the sheets for the Query to look at?

My query formula
=Unique(Query({'2/13/26'!A2:A;'1/26/26'!A2:A;'12/30/25'!A2:A;'12/17/25'!A2:A;'10/27/25'!A2:A;'9/29/25'!A2:A},"Select Col1 where LOWER(Col1) CONTAINS '"&amp;LOWER(A2)&amp;"' Order By Col1"))
I have a Column with all those Dates in a Sheet called "Dates" where "Dates!A2:A" is the list of the Sheets to be searched

Note: If needed ill create an example sheet

reddit.com
u/madbomb122 — 21 hours ago
▲ 1 r/googlesheets

I posted yesterday and got an answer that worked for a different problem but now when I am trying to use the =let function with offset to grab two columns data that is on a different sheet I cannot get past #ERROR!, Formula Parse Error.. My current formula is =LET(FGM ,OFFSET(Alex!I1:I,1,0,500) , (FGA), (OFFSET(Alex!j1:j,1,0,500),(FGM/FGA))), which gives me the error. If I get rid of the names from inside the LET function, I can get a percentage but only of the first row of cells. Please help!

reddit.com
u/Current_Bill130 — 6 days ago
▲ 7 r/googlesheets

Dynamically pulling the header of each table to a master summary sheet

Hello,

Link to start

I am currently setting up a sheet to track purchases and sales in a bit more detail than previously done and wanted to pull the headers of each table (grey rows) into a master sheet. Currently i am doing this manually but was wondering if there was a more automated way to grab those specific rows. The main issue being that the tables can be different lengths and so I don't know a way to dynamically pull from it.

I'm not tied to the formatting or structure if it if there is a better solution in another direction.

Thanks in advance

u/CharmicChameleon — 20 hours ago
▲ 2 r/googlesheets

Google Form and Google Sheet data order problem

I want to use Google Forms to enter data but need that data to come out on a Google Sheet in a different. For instance: I enter data in numerical sequence 1-10, but on the Sheet, it needs to appear in a different order.

How can I achieve that?

Background: right now data is entered into Forms the exact way it needs to appear on the Sheet.

What I'm doing now:

I am entering the data into forms in this order:

D

A

B

C

So that Sheets outputs:

D

A

B

C

OK. It works, but it's time consuming since it forces me to jump around looking for the data to input into Forms in Order.

What I want to do:

Enter data into Google Forms in this order:

A

B

C

D

So that Sheets outputs:

D

A

B

C

If this makes sense, how can I make Google Forms and Google Sheets work together to take my input the way it's in order as it is received (real life to me to Google Forms), and output in the proper order (Google Forms to Google Sheets in proper spreadsheet order)?

Thanks guys.

reddit.com
u/giftedgod — 5 days ago
▲ 2 r/googlesheets

Returning text in a cell based on the numerical value of a different cell

I am trying to make an automated character sheet for my D&D character and I've made pretty good progress, but I have hit a bit of a wall. I have an ability that changes and develops as I level up, including the name of the ability. I want to try and have the cell that defines the ability's name to be able to return the appropriate name based on the numerical value in the cell that defines my level. I'm having a hard time even finding a function to return specific text at all, much less change it based on a numerical value. Is this not possible at all or is there a scuffed way to manage it I'm not thinking of? Or best case, is there just a function I'm missing?

reddit.com
u/Six_factorial — 2 days ago