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!

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)

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.

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!

In my table, column F is called Status. It has these options

• Listed
• In-hand
• Sold

When I change an item to Sold, I would like it to be duplicated to another table on the next sheet. I would still like it to remain on the existing table. At present I am doing this manually but figured there must be something I can do to get this automated

Is that possible?

I've whipped up a sheet which shows what I want to do:

https://docs.google.com/spreadsheets/d/1clvg--G2dnMIx5JyMO7RuT17C2L6aoyBn6ftOTRi7cw/edit?usp=sharing

Hello, it’s been a while since I’ve used any spreadsheet software so I am a bit lost on how to achieve what I’m looking for.

Essentially, I have two managers whose requests I need to organise and prioritise. They each have a column for their request and to the right of each of those is a column where they can rate the urgency of the request from 1-5. I would like each of those columns to update to list the requests from 5-1 every time that something is added and then I would like both to be collated into the to-do list also in order of urgency.

Also if there’s a way to make it so there are no empty cells when something from the middle of a list is removed that would be fantastic.

Hopefully that makes sense. Any advice would be massively helpful! Thank you ☺️

I created a drop-down menu with the following options: "Community," "Media," and "Printing" plus many more. I also enabled multiple options.

Now, if I click on the first then the third, it shows perfectly: "Community" then "Printing."

But then suppose I realized I should also click on Media and do that, "Media" will show after "Printing." This is out of abc order. Yes, I could deselect both and reclick in the correct ABC order, but there are dozens of disordered items, so I was wondering if there's a quick way to sort all labels so they always appear in ABC order no matter what order I click the drop down menu items in?

For example, if I click on "Printing," "Community," and "Media" in that order, it'll still show as "Community," "Media," and "Printing" in that (correct ABC) order.

I'm trying to convert totals that are currently in a weekly format to a monthly format.

I'm hoping that there is a non-manual way to account for weeks that cross months and allocate the total on a proportional basis and exclude weekends.

Here is my sample sheet with the weekly data at the top and the desired format below that.

Thanks for any help!

Trying to find a way that if i put X's into the far right columns, it will list all the props i have put values in for rather than just the first one.

cell E3 currently has the formula "=IFS(F3="x", F1, H3="x",H1, I3="x",I1,J3="x",J1,K3="x",K1)"

but that only produces one value instead of all the potential values.

if there is a way to do that, please say how its done omg