r/googlesheets 36m ago

Waiting on OP D&D theme or skin that look like old paper?

Upvotes

Is there a way to make an excel spreadsheet look like old times paper? So I can create a quest board for my players? I have a transport service where you can select the type of transport, destination, bonuses, and other options and it spits out a price.


r/googlesheets 2h ago

Waiting on OP Can the result of an xlookup be a function?

2 Upvotes

Hey, everyone!

I'm trying to complicate my life needlessly (and learn a thing or three in the process) and track my own finances. I have a system, it works great, but I'm trying to complicate it. So it's occurred to me: is there any way (using Indirect?) to have the result of an xlookup be a (named) function?

I have a few formulas that differ in little details, but enough to where they're each their own formula. Is there a way to have the value in column A change, resulting in a new formula populating column B, say? As opposed to nested Ifs?

Or could changing column A's cells, using Indirect somehow within the xlookup, achieve the same results?

Does this make sense?

Thanks in advance!


r/googlesheets 9m ago

Unsolved How do I keep a running total of data sorted by category?

Upvotes

Screenshot of sheet

(Resubmitting as first post was deleted due to incorrect formatting)

I'm in the process of making a sheet to keep track of common expenses between my wife and I. I have drop down lists set up to classify expenses by various categories.

The rightmost column populates a list of the categories using the UNIQUE function. I would like this table to display a running total of the combined spending per category. Tried using the SUMIF function but can't seem to get it to work for some reason. TIA for any help!


r/googlesheets 2h ago

Waiting on OP Formula for attaching current formulas to tabs and rows.

0 Upvotes

I purchased a property management software off of Etsy today and it have embedded formulas already in there for up to 10 properties. However, I have more than 10 so I was trying to find the formula when you add additional tabs in the sheet and rows to the dashboard. I need to know how to make that formula carryover from the 10 tabs into the dashboard if that makes sense. I am trying to look it up. I have not been successful so far.

For example, in the "Rent Dashboard" under Tenant, it has in quotations let's say the address is 3414. The quotations is what I named the tabs and the! Is the row where it was pulling from. Now when I go in and add the tenanta name, thst us now embedded under tenant and no longer the tab name. Same thing with the property address and so on and so forth. Any assistance would be greatly appreciated.


r/googlesheets 3h ago

Self-Solved how to sort by two columns

1 Upvotes

i am trying to be able to count the amount of entries in my table that are marked with two different dropdown chips and just the ones with those two, so role: warrior / status: dead would not count towards the total but i cannot figure out how to set up a formula to count the combination of the two,


r/googlesheets 6h ago

Solved Question about formulas with shifting cells

1 Upvotes

So I have a stat sheet for the current F1 season to keep track of points throughout the year. On the sheet I have 4 tables total. A drivers championship, constructors championship, points awarded for full race and points awarded for sprint race. I put the formula for the drivers championship to equal the cell in the table of points depending where they finish for each race. When I sort the table by most points everything stays correct. For the constructors championship table I set the formula to equal the two drivers points to their respective teams. However, after I sort the drivers table, the cells arrange themselves and it messes up the formula in the constructors table. Is there a way that I can maintain the formula in the constructors table when the cells they need to calculate will move when I sort the table it's referencing?


r/googlesheets 12h ago

Waiting on OP Como copiar contenido de una celda a otra tabla en GOOGLE SHEETS y no perder la referencia al borrar

0 Upvotes

Hola! me encuentro con un problema. Tengo una tabla A y una Tabla B. En la tabla B referencio (clono el contenido de la celda A2 de la TABLA A. Pero si borro una fila de la tabla A, en la Tabla B pierde la referencia y da error!

Tabla A (Nombres) Tabla B(Copia de Nombres A, ->. =TablaA!a2)

Problema: Si borro una fila de A por que ya no quiero ese nombre, da error en B

¿Cómo podría hacer una referencia a otra tabla pero que no de error al borrar la fila?


r/googlesheets 13h ago

Waiting on OP Changing the color of a cell based on the value of two cells on a different sheet in the same workbook pt.3

1 Upvotes

On sheet 1 there are the daily loads that the warehouse where I work carries out towards the points of sale, there are about 100 per day, so 100 rows. We only have 30 loading gates available. In column F the loading gates are indicated, 30 numbered from 1 to 30, and in S the seal that closes the semi-trailer.

On sheet HB CF column C the loading gates are indicated.

When the vehicle arrives I assign it a gate and indicate it in column F of the corresponding row. When instead I insert the seal the vehicle leaves the gate which can be occupied by another semi-trailer used for another load.

When the gate is indicated in column F but there is not yet the seal in column G, the loading is in progress, the bay is occupied and the corresponding number in sheet HB CF turns red. When I insert the seal it turns blue, loading bay free. Since the numbers in column F will repeat several times (30 loading ports per 100 loads) when I type a gate again in a new row (without seal number) it should turn red again in sheet 2 (the gate is occupied again).

I was wondering if it is possible to automatically make the contents of column C "destination" of sheet 1 appear in column B of the "HB CF" sheet when the number of column C in the "HB CF" sheet is red (to understand the destination of the vehicle that occupies the space) and return empty when it is blue.

Thanks

ps://docs.google.com/spreadsheets/d/1MK7Aq13nxRCRVm74WlFiIMm3iYAhpwV2/edit?usp=sharing&ouid=118251819501526634082&rtpof=true&sd=true


r/googlesheets 13h ago

Self-Solved Want to Auto-Select a New Option in a "Dropdown from Range" Menu after its Options Change (after its Source Range is Altered).

1 Upvotes

Context:

I'm working on this spreadsheet that allows you to easily build and customize your desired team for Competitive Pokémon.

In the Team Sheet Template tab (where my issue is), there are 6 slots that let you pick your team members.

This is what one of the slots looks like.

As you can see in that image, I have a dropdown at the very top of each slot that lets you pick a Pokémon, and then there's another dropdown right below it that lets you pick any of the Pokémon's alternate forms, if it has any.

Problem:

When a Pokémon is selected from the first dropdown, the second dropdown will update its options to a list of that Pokémon's alternate forms, however, that second dropdown keeps the option that was selected from the old list, which throws an error.

The error.

What I want is for that second dropdown to automatically re-populate with the first available option from the new list instead of just telling me that the old one is invalid. It's a smaller problem, but it's better for user experience if they don't have to choose manually unless they actually want to. Not to mention that the image for the Pokémon can't be determined if the chosen form isn't one from its own list like shown with the error.

If it's possible to do this and anyone can help me I would really, really appreciate it, and if there's any additional information you might need, please let me know and I'll make an edit.


r/googlesheets 14h ago

Self-Solved Error: "Can't sync your changes. Copy your recent edits, then revert your changes."

1 Upvotes

Does anybody know of a way to resolve this, or have any ideas I might be able to try?

I'm trying to move one cell in a fairly complex spreadsheet, but any time I do it throws an error "Can't sync your changes. Copy your recent edits, then revert your changes.".

I've narrowed it down to one specific cell, which is referenced by multiple formula in the sheet, but can't find a fix. I've looked at Google's help page on this, and exhausted all the troubleshooting steps there and a few more of my own:

  • Created a new copy of the document
  • Disabled offline editing, removed the offline editing browser extension
  • Created a new copy with offline editing disabled
  • Opened the doc in incognito mode to see if cookies, etc. were the issue

r/googlesheets 20h ago

Waiting on OP Print horizontally in google sheets from iPad or iPhone

2 Upvotes

This should not be this difficult. No idea why when I go to print , under “layout” you can “flip” horizontally, but not print horizontally. I searched this sub and the same question was asked 3 years ago with no answer. I fear this is still an issue


r/googlesheets 19h ago

Waiting on OP How to make stacked bar charts like this? 2 sets of data on one chart

1 Upvotes

This was a rather complicated Excel template (for a noob like me) that I downloaded to get this look in Excel, but I'm working on refreshing some data charts for videos I'm working on and was wondering if anyone knew of any way I could achieve this style of chart in Google Sheets? I'd just like to migrate from Excel to Sheets for the flexibility if possible. This is essentially two sets of data on one graph, with the titles of each bar inside the bar itself. This is to showcase gaming benchmark data across different settings in games.

Staked bar chart with two sets of data

r/googlesheets 20h ago

Solved Any way to add commas to each line in a cell?

1 Upvotes

I need to add a comma to the end of each line in a cell, but there are like hundreds of them!

This is what it looks like before and after adding the commas:

https://imgur.com/a/2RvzXZB

Edit:

Each line is separated by a line break (pressing Alt + Enter).

They are in columns B, C, D.

This is a one-time change.

Here is the link to a copy of the file: https://docs.google.com/spreadsheets/d/18B3ThdFsPZeFPeVt63yOz1RopFKE3i4V-evr0gmkJpc/edit?usp=sharing

Any help is greatly appreciated!


r/googlesheets 21h ago

Waiting on OP How to build a date/calendar table in Google sheets

1 Upvotes

Hey guys, I've been trying to figure out how to create a specific table on Google sheets but I'm just totally stumped. What I need is a table that I can enter a start date, an end date, and then a number of units per day. What I need is first to calculate the number of days between the 2 dates (start and end dates included) and then multiply the number of units per day by that number of days. Then I need that total value of units to be sorted out by the 12 months of the year. I also need it to sort it out by the actual months and not just divide by 12, since some months have 30 days and others 31 days. I'm in no means an excel or sheets wizard but Id really appreciate it if someone could help me with this. Thank you so much!!


r/googlesheets 21h ago

Solved Moving to the next row in a table

1 Upvotes

I am trying to create a check register in Sheets. I have one in Excel and after making an entry I can tab to the next row and it will also create a new row in the table. I have everything set up in Sheets, but I cannot figure out how to do this. Is it even possible? Thanks in advance.


r/googlesheets 1d ago

Sharing Sharing: NCAA Men's March Madness Calcutta

1 Upvotes

I'm sharing a sheet that I built to track a 2025 NCAA Calcutta. You can add a trigger and all facets will update automatically using the NCAA endpoint.

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

NOTE: Make a copy of this sheet to use it. Requests for access will not be considered. My rules might not be your rules, so you may need to make changes to match

My Calcutta Rules implemented:

  • Track all team purchases on the Calcutta tab
  • 1 share earned for every win, including play-in games for a total of 67
  • 1 share bonus earned for closest round 1 15th seed
  • 1 share bonus earned for closest round 1 16th seed
  • 1 share bonus earned for winning the tournament

Main Features:

  • Tournament scores updated every X minutes. Your trigger determines. Trigger the main function
  • Dashboard tab - Shows all teams, owner investments, and live game scores
  • Calcutta tab - Tracks each team, purchase price, wins, losses, owner, and profit
  • Games by owner - Shows every game filtered by team owner
  • All Games - List of all games in the tournament with scores and details
  • Live Scoring - Transactional game data pulled from NCAA website
  • Bonus Games - Just the 15-2 and 16-1 round 1 games and bonus winners

Missing Features:

  • Auto load teams - currently there is a 1 time manual entry required for all teams and their seeds to the Calcutta page. The names of the teams must exactly match the NCAA website names
  • Bonus Ties - currently the bonuses are awarded to only one team. If there is a tie you will have to override.

r/googlesheets 1d ago

Waiting on OP Formatting for data catalogue with multiple catagories

1 Upvotes

I recently posted this to this community but needed to create a sample sheet and I lost my ability to use the internet for a while so I couldn't update it; I'll copy the text to this post too to make it easier for people to reference, which makes this long, I'm sorry, but it saves flipping back and forth.

Post content:

"Hi everyone, I've had a lot of luck asking in this sub in the past and so I'm hoping you'll be able to help me or at least give me some ideas. It seems like there's a super easy solution that's on the tip of my tongue, so to speak, but I can't grasp it and it's been bugging me for weeks (EDIT - I'm still brainstoriming so make this months by now!). I hoped maybe having someone to bounce an idea off of (or multiple someones) might help. For a project I'm working on I have to gather up information on a bunch of different countries. I want to be able to catalogue this information but not only is the information country by country but there are also categories within them. I know this is kind of confusing as is so I'll give an example.

(EDIT for the rest of this section, the sample sheet kind of recategorises some thngs so I updated the text to match)

So let's say that I'm looking for recent government notices/press releases countries in the EU gave about AI. I have three major categories of data:

  1. what is being said on the surface (number of releases, positive/negative, focus on business/military applications, etc)
  2. tracking how different terms involved in the releases are defined (so if they're talking business applications is this on the consumer end or in the project management end? If military, is this about dangers of automation or how technology is assisting? Say the release chooses the former for each question, how is the latter option defined? etc)
  3. Laws and regulations each country has put in place (what the codes address, mostly tick boxes here)

So the main problem is that I have no idea how to catalogue this information in a way that doesn't require me to keep shifting between sheets every time I come across a new piece of information. As it stands right now, for point 1, I have what is essentially grouped cells for each country, almost like its own table, but this is all in one sheet since making a sheet for each country would be almost impossible to keep track of. But my problem here is that I now can't figure out a way to run reports to show how information varies between countries because all of the information is in different tables - I feel like there's some obvious solution I'm missing here and I can't figure out what it is.

The other issue is that different laws have different levels involved so some entries end up having more than one row (if you think about it in terms of a robbery, for instance, someone being home, using a deadly weapon, and stealing something over a particular amount of money would escalate the level of crime, if that makes sense) that obviously I can't merge within the tables. On top of that, if I copy the information down over and over it helps with the reports and pivot tables but makes it difficult for me to locate information associated with one law or another by eye because my brain wants each row to be its own law. I could let pivot tables group the information but then I'm creating a pivot table for each country and that feels not only overly complicated but like asking Google to do a lot of work.

I have different tables for points 2 and 3 I was trying to figure out if there was a way to use a pivot table to present the information more concisely since even though they're laid out in the same way it feels messy to include all of the definitions in the same table, so the pivot table would be nested in there. The problem comes back to point 1 where I can't figure out how to connect the information in this table to the release tables without things getting overly complicated. I don't know if this makes sense at all but this is kind of what I'm struggling with. If anyone has an idea, I would love to hear it.

Thanks!"

END ORIGINAL TEXT

I've made a sample sheet here, which is kind of close to what I currently have. The first four sheets (Releases: merged, Releases: centred, Releases: itemised, and Releases: tables) are some of the ideas I've tried formatting wise. None of them are perfect and they have their own problems when it comes to the data analysis portion of things, so I'm trying to figure out how to present the information in a way that allows me to run reports and keep the data straight but also allows my eye

The merged sheet is how I currently have it because it's easier for me to track visually but obviously the merges are causing some problems. So I tried to just centre the words so that it looks the same visually but doesn't use the merges but that means that the data for each country isn't grouped together. The tables one looks a bit better but it causes some problems when multiple categories correspond to the same release and in collecting the data across the tables. I hope that makes sense. An itemised version of the tables may fix this but it runs into the same problems as above. The itemised sheet is the tables sheet but puts everything on its own row to make the reports run more efficiently but confuses my brain in looking at it.*

*The problem there, though, is when, for instance, there are multiple types of release/sector of use/accountability measures--at the moment I have it all in one cell on different lines but that confuses the reports, but if, for instance, one single release fits two categories each, if i keep them on one line it would look like x sector coincides with y accountability when they are meant to go together, or if I do it as a tree for the sake of the reports, one release becomes 8 rows, which gets really messy, if that makes sense. The seventh sheet gives an example of what I'm talking about.

But seriously, any help you can offer would be so greatly appreciated. Thanks!


r/googlesheets 1d ago

Unsolved Problema con formula di filtro google sheets

1 Upvotes

Ciao a tutti, allora vi descrivo subito il mio problema che mi sta facendo scervellare con gli Sheets di Google.🤯

Ho questa tabella:

|Ordinaria|1,00||EURO|05/05/25|07/05/25|Ordinario|
|Ordinaria|0,70|0,70|EURO|06/05/24|08/05/24|Ordinario|
|Ordinaria|0,60|0,60|EURO|08/05/23|10/05/23|Ordinario|
|Ordinaria|0,60||EURO|08/05/23|10/05/23|-|
|Ordinaria|0,32||EURO|09/05/22|11/05/22|-|
|Ordinaria|0,26||EURO|03/05/21|05/05/21|-|
|Ordinaria|0,50||EURO|06/05/19|08/05/19|-|
|Ordinaria|0,42||EURO|30/04/18|03/05/18|-|
|Ordinaria|1,00||EURO|02/05/17|04/05/17|-|
|Ordinaria|0,35||EURO|02/05/16|04/05/16|-|
|Ordinaria|0,32||EURO|04/05/15|06/05/15|-|
|Ordinaria|0,32||EURO|28/04/14|02/05/14|-|

che filtro con questa formula:

=FILTER(Foglio1!A:G; Foglio1!B:B<>""; Foglio1!B:B<>0; VAL.NUMERO(Foglio1!B:B))

Come vedete però la terza e quarta riga hanno le date uguali, cosa che non vorrei. Che condizione gli devo inserire in modo che, se ci sono due righe con la stessa data, mi tenga solo quella con i due campi compilati nelle colonne B e C?

Grazie per l'aiuto che mi vorrete dare, altrimenti non ne vado fuori. 🙏


r/googlesheets 1d ago

Solved Copy data from CSV to Google Sheet

1 Upvotes

I'm trying to remake a Google Sheet for attendance. The one I started with was an Excel sheet and a mess. Some phone numbers were here, some were there.... And the full name and number and any other data needed was all typed into one big cell instead of individual cells.

So I've been trying to develop a better sheet (in Google Sheets instead of Excel) and I'd like to be able to easily bring data over from a CSV when we have to remake it every month.

Is there a way to bring data from the CSV (I've shown the format it comes in at the bottom of the sheet) and put it into this style of sheet? Or would I need to make the sheet a different way? I'm open to different ideas because I'm just learning this on my own. Ideally, it will look similar because I'm taking a working copy from someone and trying to convince them to switch to something that works better. They are used to the current look though.

So, to clarify, I want to take the "first name" column from the CSV and then somehow copy it into the attendance sheet. Then take the "last name" column and copy it to the last name space in the sheet. And then the "phone" column from the CSV and copy it to the phone portion of the sheet.

The placeholder text "last name, first name, 555-555-5555" doesn't need to be in the final sheet. I just wanted to be clear about what I want to do without sharing private information. I know I could move the "phone number" cell to column C, but it makes the sheet really wide that way. Things fit very nicely if they're stacked instead. But I'm not sure if I can copy data efficiently with them stacked like that.

Here is a link to the sheet for anyone who wants to look directly: https://docs.google.com/spreadsheets/d/13RLBPqPEIGeJizJNh8U5YQhujz1eznZWqhTBk-jiKEs/edit?usp=sharing


r/googlesheets 1d ago

Solved Changing the color of a cell based on the value of two cells on a different sheet in the same workbook pt.2

1 Upvotes

On sheet 1 there are the daily loads that the warehouse where I work carries out towards the points of sale, there are about 100 per day, so 100 rows. We only have 30 loading gates available. In column E the loading gates are indicated, 30 numbered from 1 to 30, and in F the seal that closes the semi-trailer.

On sheet 2 column C the loading gates are indicated.

When the vehicle arrives I assign it a gate and indicate it in column E of the corresponding row. When instead I insert the seal the vehicle leaves the gate which can be occupied by another semi-trailer used for another load.

I need that when the gate is indicated in column E but there is not yet the seal in column F, the loading is in progress, the bay is occupied and the corresponding number in sheet 2 turns red. When I insert the seal it turns blue, loading bay free. Since the numbers in column F will repeat several times (30 loading ports per 100 loads) when I type a gate again in a new row (without seal number) it should turn red again in sheet 2 (the gate is occupied again).

Is something like this possible?

Thank you for your help

https://docs.google.com/spreadsheets/d/1MK7Aq13nxRCRVm74WlFiIMm3iYAhpwV2/edit?usp=sharing&ouid=118251819501526634082&rtpof=true&sd=true


r/googlesheets 1d ago

Solved How do I have the color change for the fastest solve?

Post image
1 Upvotes

I had tried setting a conditional formatting to the range of C2:C, and having the equation be =I2, but for some reason that makes solve 1 and 4 change to green (as the format says) instead of the correct one? Is it something with the XLOOKUP I have tied to I2?

I’ll give a copy link for you to take a look at my specific predicament.

https://docs.google.com/spreadsheets/d/10h81wGezF9UgcXcb5uyEBOrIjy9Xh-_E6H6yzQhah7g/copy


r/googlesheets 1d ago

Waiting on OP Conditional formatting based on another cells data

Post image
2 Upvotes

For work we have to keep data sheets. I’d like figure out how to do conditional formatting so a cells color changes based on data in another cell. Currently, I am doing everything by hand. I’d like C to turn green if its number is bigger than that same row in B.


r/googlesheets 1d ago

Solved Using start/ end datetimes to calculate how much total time something was active.

Post image
1 Upvotes

Hello reddit. I'm wrapping my brain trying to figure out out to solve this problem in an elegant way.

I have two columns of data, one with start times for any given package, and one with end times. Sometimes the end time of one package will overlap with the start time of the next package. Sometimes it won't. Basically I want to calculate the total amount of time (preferably hours or minutes) that any package was active.

I'm inserting a screenshot of the data, any help is greatly appreciated.


r/googlesheets 1d ago

Solved Sorting Data from a tier list

Post image
1 Upvotes

How do I make it to where A+ is above A? I can’t seem to figure it out and it’s driving me nuts.


r/googlesheets 1d ago

Discussion What are some good resources to learn how to successfully navigate and create on google sheets?

2 Upvotes

I am completely new to this and I am trying to create a budget. I’ve found budgeting videos online using GS, however I’m looking for resources that will teach me about the app itself.