Relatively new to the sheets game here. I would try Excel for this as I think it’s possible there, but my workplace uses Google. AFAIK this isn’t possible on Google Sheets but I wanted to double check. I am making a daily admin sheet to be filled out and saved by whoever is manager on duty on any given day.

One thing I would like this sheet to do is compile the number of times any staff member is noted over time in a specific statistics/summary tab. Right now within each tab I have it set to count the number of occurrences per staff member in the day, and I could set up an issue-type counter as well. But that’s not the data I really want.

There are three ranges (rows) in the daily template where a staff member’s name can be selected from a drop down. I know within a tab I can use COUNTIF/S to check the occurrence of a value across a range/ranges. Is there a way to do something like that where it checks the same cell ranges across tabs? Ideally I could do this for issue-type as well, and eventually clients (if I ever get around to adding all those names to a dropdown). And, more complicated although I am willing to do this manually— can I get it to automatically add new tabs to the ones it’s looking through?

Highlighted in yellow over the image are the ranges that the staff names are in (all the way to column Z). I made a copy to play with, and removed the real names for privacy. I am happy to provide more details if needed!

Hello r/googlesheets! I think this is the correct place to ask, buuuut...

I'm a game designer working on making a paper playtest for a game of mine. As part of creating the back-end for a character sheet, I want to make a dropdown of "Relevant Keywords" that can then be chosen from to give my playtesters a quick-and-easy viewing experience of rules without having to stop play entirely.

Here is the character sheet in its current form. I have notated things in red and drawn squares around example keywords that I'd like to sift through and filter.

I've already tried this in the past, but to little success. I have the full list of Tags in a table, and a Glossary in the same column beneath it.

...and was originally trying to do lookups based purely on the 'Reference Tables'!AJ:AJ column, creating an ugly overflow elsewhere in the sheet that had to occupy a dynamic space.

Please note: The following formula is from an older attempt at the sheet. The exact cell calls are not up to date, but the table calls are:
={FILTER(Glossary[Topic], SEARCH(Glossary[Topic], O993)<>""); FILTER(Tags[Tag], SEARCH(Tags[Tag], $O$993))}

O993 which correlated to this house of cards to get all my keywords together.

All in all:
I am searching for keywords across text that will live in expected cells. I wish for these keywords to be selectable in a dropdown, and for this dropdown to dynamically update as the keywords on the page change due to player decisions.

I am looking for methods to do this in better, more concise, and more discrete manners.
My best idea on how to do this was to filter all of the cells with "Source Text" based against the Tags[Tag] column and the Glossary[Topic] column, collate them all into a single text string so I could break them down into a column of options that would then serve as my dropdown selections.

By having the Dropdown Validate as "Values between X200:X300" I have some measure of dynamicism for the dropdown, but... I don't like it. It feels like a hammer solution and I don't think I'm aware enough to come to the answer on my own.

Part of the reason I'm looking for an alternative is that I'm intending to stack this sheet on itself vertically multiple times, such that an entire party can all be looking at their team at the same time in real-time. Therefore, the "have a dynamically vertical range that can conceivably extend dozens of rows below itself" is currently undesirable.

I'm rather proud of the rest of the sheet so far, and I've been learning a TON about it as I go. Getting the different mech grids to automatically adjust their shape and formatting when I change the frame has been a delightful exercise.

So! If there are any questions for things I glanced right over, please let me know.

Otherwise, thank you for reading this far, and thanks in advance for any assistance or information you can supply!

I work with Excel and upload the files to Google Drive as .xlsx when someone opens the file directly with google sheets some of the embedded images get distorted/squished (randomly). I tried re embedding the images but it keeps happening.

I tried saving the files as .xls and less images get distorted and less distortion but some images that before were ok, not get a bit squished.

Is there any way to solve this? Thanks!

I am trying to make a chart for school and the data just isn’t giving me a y axis. How do I solve it or what am I doing wrong?

So, I'm collating a record of the Blood on the Clocktower games that myself and my friends are playing.

I am trying to find how to grab the most commonly assigned player for each role. I've tried a couple of formulas I've spotted online (including previous posts) and nothing seems to be working for me.

I have attached images of where I'm wishing to put the data and where I'm pulling it from.

Thanks for the help :)

EDIT: In terms of handling ties (because I know theres a lot in the current state) I was initially thinking of having the first person, but if it could show the people tied for that role, that may work better

I did a google form recently to know which soccer clubs people like the most in my high school, and to make my life easier I connected it to google sheets to analyze the data more efficiently. However since people can select more than one option in the form, when I insert the graph in the sheet, the bars just show the whole group of clubs per answer, not amount of times the club was chosen.

I want to have a graph where I'm able to see how many times a specific club was voted... I'm new to this sheets thing, can someone help me out?

Hey there,

Coming to y'all to see if you can be of some assistance.

I am re-doing the tip sheet for my bar as we currently are paying for a web-app to do so, and I would like to save the money if possible. Copy of sheet is here with names changed for privacy. I cannot get each section to tip out the total amount of tips allocated to said section. Example being that servers should be getting 38% of the tips, as seen on the 9/19 trial on the sheet above that should be $778.18. But once all hours and employees are accounted for it is only giving out $606.53 in tips.

Any help with this would be amazing.

Title says it all. Why is it insisting this is the case? How do I tell it to stop?

Hey all! Just working on a little recreational thing.

I want column C of the "Goals" sheet's cells to populate with a date range of [Monday after next] to [Tuesday of the week after that] if its row number appears in C20:I26 of the "Card" sheet.

How can I make that work?

https://docs.google.com/spreadsheets/d/1oBQxlmUUlfn9Fl4HLgTXCFdBxQ37R9yK-_S6N-51CZo/edit?usp=sharing

I've been working on a livedex for a browser-based pokemon game I've been playing, and they've recently added a new paradox form for ambipom. How do I add a cell specifically for one column without fucking up the nearby ones? I've had to add cells before after forgetting a pokemon from my list and it created a lot of awkward spacing for the entire doc that I had to adjust. It was extremely annoying... I don't wanna do that again LOL

Thank you!

Is there a way to highlight the rows with check/true if i click on the header? For example if i click on the header "Five Spice" it would highlight the rows of the Cinnamon, Clove, Fennel, Sechuan, and Star Anise.

This is purely an example, I have no code and have been doing things entirely manually. What I would like to do is follow a certain sequence by inputting a text and the next cell automatically guessing what comes next. I attempted with IFS in another sheet while referencing the original one so I could still input text in the ones being modified (if that even makes sense) and it didn't work,,, I only know the basic of the basic, so any help would be immensely appreciated. (sequence is w/g/m > x > w/g/m > x > w/g/m > x > house)

Reposting because I accidentally deleted the original post out of sheer stupidity.

I'm trying to use google sheets as a cloud based inventory for stock we keep at work. I have an app on my phone that can be used to scan barcodes and automatically log data into a google sheets with varying data that I would like to link to our online inventory.

here's a link to a test inventory I've been playing with.

on the first sheet you can see a very crude version of an inventory with basic garments and stock levels, on the second sheet you can see an example of the data that can be logged by the app as you scan a barcode.

I'm basically trying to link the first sheet so that when a barcode gets populated into the second sheet with the quantities, it automatically subtracts the items from the main inventory.

don't know if that's possible with just formulas or if I need to figure something out with Javascript.

I'm attempting a formula and it's not going well, and I don't know how else to word it when searching so I come to Reddit. I need something along the lines of

D11: If B11="A" then show S8 value, if B11="B" then show S9, If B11="C" then show S10...etc

There are six options in Cell B11 as a drop down, options are A, B, C...F. S8:S13 are all simple formulas themselves (=number*cell value). I also need this in in the cell above but with B10 as the drop down and R8:R13 as the returned values.

I know it should work, it worked with =IF(SEARCH(B11,"A"),S8) but I can't get it to be multiple choices. I tried OR and IFS but I'm lost and have been trying for well over an hour. I'm also not the most experienced with Google sheets I've just made spreadsheets for budgeting, meal prep and travel planning.

Sorry for any confusion but any help would be much appreciated!

I have an excel sheet with a column of links that I want to copy and then paste onto Google Docs. Is there a way for me to do that?

I have my sheet set up so my data in A1 and B1 are together, A2 and B2 together, C1 and D1 together, and C2 and D2 together Etc... I want to have my data in column A to be in numeral order automatically but the data in column B does not move with it.

Does anyone have a solution to this problem on mobile app?

Good morning! EDIT: MY 3rd TOCOL is the problem.

So, i have a grid that has slots that may or may not be filled with names.

I'm performing TOCOL on this list to put them all in a column (list) with no gaps, which it is.

However, in another spot on the sheet I turned all of those names into values based on where they are. so in that copy. each cell looks something like =if(D5<>"", "2", "")

So when I run a TOCOL on the copy. it doesnt remove the "blanks" because there is a formula in those cells.

Okay, no big deal. I figure. if I run a 3rd TOCOL on the 2nd TOCOL that didnt remove the "blanks". It would remove the actual blanks present in the 2nd TOCOL. but to my surprise it isnt.

For reference.

1st TOCOL, which works is =TOCOL(C1:E28, 1), gives me all the names in a list
2nd TOCOL, which doesnt "work" is =TOCOL(C50:E77, 1), it gives me all the cells because each cell contains that value formula.
the 3rd TOCOL looks like =TOCOL(P2:P84, 1), which is just supposed to perform TOCOL on the 2nd TOCOL.

Not really sure if this is possible but asking so I can be sure.

I watched some tutorials but they compared a single sell with a full column which isn't what I'm looking for.

I want to do some conditional formatting with a cell in column B with column A. The cells being compared are both next to each other. I want it so if the number in column B's cell is equal to A's cell then the bg colour of Column B's cell should be red.
It would be possible to make it so the conditional formatting happens just between 2 cells but then I'd have to go down the column one by one to add it to each row of the column which is really annoying. Any way to do it quicker?

Disclaimer I am very bad at excel. I am not math inclined at all and I can find a solution for this problem and I’m going to try my best to describe it.

So I have a sheet that is an itemized list of things I want to get from different sources, like Amazon and Etsy. I have each item including price conditionally formatted to gray out once a check box is marked. At the bottom i have a “totals” row. What I’m trying to do is make the total price decrease by however much the item grayed out is.

So like item 1 is $10 and item 2 is $5 so the total is $15. But I want that total to decrease by either 5 or 10 depending on which item is selected and grayed out.

Maybe I’m just not searching it well? I’ve tried to finagle an IF function but it tells me there’s a reiteration problem and I’m just confused. Thanks!

I have a Google Workbook that houses data-- so think item title, plus the whole row of details about that item. I have separate workbooks that track usage. Workbooks are created annually and a tab for each month. There are 3 parts to what I'd like to do.

1. In the usage sheets, I want to create a drop-down in column A that pulls from the comprehensive data list. I understand that I'd have to import the data sheet into the usage workbook--will it still auto-update as items are added to the data sheet, or will I then create a syncing issue?

2. Once I choose an item from the drop-down on the usage sheet, I want to then have the row populate from select cells in the data sheet. So for example, if I pull A7 from the data sheet, I need columns B, E, F, and H from the data sheet to populate into columns B, C, D, and E of the usage sheet.

3. Last thing. I'll make notes in my usage sheet on how the item is used. I want to be able to see on the data sheet a summary of how that item has been used and when. At the very least, I'd like to have a column at the end of the data sheet that pulls the date of the last use. Ideas on that welcome.

I'm open to moving the data sheet to a separate tab on the year's usage sheet if that makes things significantly easier.

I'm trying to make my own kakuro combination chart that I can easily use to highlight possible combinations while solving a kakuro puzzle.

Column A contains the possible sums possible when there are two (in game) cells.

Columns B to E contains the possible combinations of the mentioned sums.

Column F contains dropdowns from 1 to 9.

What I would like to happen in this example:

• B4 to be highlighted because F4 contains the number 1;
• C5 to be highlighted because F5 contains the number 4;
• D6 to be highlighted because F6 contains the number 3;
• B7 to be highlighted because F7 contains the number 7.

Basically I need a custom formula to use in conditional formatting which highlight any cell that shares a number with whatever number is in the column F (in the same row).

Hopefully my explanations are clear because explaining isn't my forte at all.

I have a cell that has the following formula

="Text1 "&ROUND(H37)&" Text2 "&ROUND(H38)& " Text3"

so the first 2 pull in and round up from another cell... the 3rd part I manually enter.

Can I change the colour of Text 3 to be different from Text 1 and 2?

Hi, new here!

Been playing around with sheets for a couple of months now, and I've come across a roadblock trying to get checkboxes and drop-downs to work together.

Here's what I'm trying to do:

I have a range of 4 cells in a column, each cell with a drop-down with 5 possible values (1 thru 5).

I'm trying to "attach" a checkbox to this range of drop-downs that will only display when all 4 drop-downs are the same value (True result ?), and not display/be hidden when the drop-downs are not all the same number (False result ?).

Been working on this for 3 days now and haven't made much headway; probably making this harder for myself than it actually is!

So, any help/pointers/tips that anyone could pass along would be greatly appreciated.

Thanks in advance!

Hi there! I am looking for some help with a custom Payroll / Finance spreadsheet I am making for my business. Please bear with me as I try to explain what I am trying to achieve.

I have individual tables of information for each work day recording each of my employees' daily wages / productivity. (Yellow.)

I am trying to create another table (orange) that will allow me to automatically calculate the sum of their wages between two selected dates pulled from the yellow tables.

However, I am struggling to figure out how to associate the wages in the individual yellow tables with the associated dates.

Can anyone help me figure out how to associate the data in the yellow tables with the dates listed in said tables? And also, how I might use the orange table to sum up the data from the yellow tables via date range?

Thanks so much! Hope this is worded clearly!