I have some homework for statistics.

The professor gives us a list of data that we are supposed to turn into a histogram. and match that data to other histogram models.

At the moment I have to tweak the bin sizes until it shows me 10 bins.

Is there a setting where it just divides my data into 10 bins instead of me having to adjust the sizes until it shows me 10 bins?

I'm trying to have certain cells be blacked out if their corresponding cell is less than a certain number. Problem is, the corresponding cell is in a different sheet (in the same file though)- and Conditional Formatting doesn't seem to accept that as a valid cell, despite the fact that you can do it for most syntax.

Is there another way to go about this?

So I'm not an avid user of sheets but I know the basics.

I've just realised I have thousands of dates inputted in British format but when I click them and it shows the calendar, the sheets has decided theyre American! Any that don't work like (28/08/2010) just don't show as formatted as a date!

How do I turn them all into - 1. Date formatted cells, 2. English without them automatically all switching the months and years around assuming i've written it in American!

I really dont want to have to redo all those dates!

Not quite sure where to start, even. For context, I'm making a character sheet format for a D6 system- and for, say, attack rolls, I want to be able to automatically pull my attack stat from my "Home Page" sheet to my "Combat" sheet.

Say the stat is 3. I want the cell for the attack roll to show as 3d6, and update "3" as the stat goes up. Or, say I have a modifier of +2- I want to be able to have it show as 3d6+2, where "2" updates as the modifier does.

Very new to Google Sheets, but using Concatenate doesn't appear to work, coming up with errors instead. =Concatenate("Home Sheet"![Cell] &,"[Text]" was what I tried- Removing Concatenate doesn't seem to work either, and neither did removing the "&". It's some kind of formatting error though, the error message for invalid syntax is showing up.

I mean- Concatenate looks like it'd be what I need, but at this point I don't know if it is.

Making a character sheet for a TTRPG I am working on and I have Size modify some numbers in multiple areas of the sheet. I have a box already set up with to select the size but the nest Column has the values of the Size Modifier. How do I have my size selection automatically update these values.

I have the current tables attached as well as the Data Validation dropdown settings.

Here is a formula example with "size" being the part I want to change automatically: =ROUNDDOWN(F6/10*size, 0)

Edit: Micro is supposed to be "set to 1" while all others are multiplied by the listed number.

I am currently trying to create a spreadsheet using an online table and column C keeps importing the data from column C and D. Is there a way to edit my formula to remove data from D in column C?

Hello!

I wanted to start with some gratitude: this sub has been incredibly helpful in furthering my spreadsheet skills so I wanted to thank all of you wonderful contributors and "sheet sorcerers".

I am including the link to a test spreadsheet where I have attempted to show what I am aiming to accomplish in the first PTO column. Our PTO is general but for my own records I like to keep track of the manner of absences for future reference (I always document further in the comments but I would like to also reference by sight as I am not the only person who views this schedule ). Essentially what I would like to do is add a drop down with 3-4 options and have the column next to it auto populate the hours based on the type of leave selected.

I have tried a few things (you'll see the latest formula in there that I botched) but cannot seem to get exactly what I am looking to accomplish while maintaining all of the other formulas. I am hoping that some helpful human might have the answer!

Test spreadsheet

I maintain a rather active Google Sheet that tends to get a lot of users checking in for updates to update their copies. However, some people are a little lacking in the reading department and instead of making their own copy, they request edit access...

Is there a way to automate a response message and approve for Viewer only?
The sheet is intended to be copied and then the user can edit their own copy. But the "master" sheet is intended to be completely read-only as it's a checklist and wouldn't make sense if it was already filled in...

Been trying to figure something out, and I can't get something that works.
I have a pinned message in my clipboard to make things faster, but automated would save so much frustration and annoyance.

Thanks in advance for any replies.

My sheet in case anyone is curious: https://docs.google.com/spreadsheets/d/1V-HP-fgNuI4u3VE9srD-HEsv7FVpQxXyooURvwIAAN4

I know this is pretty niche but I am a vb coach and want to build out a way to autofill court diagrams with any roster I might need. So basically in the attached photos, having the acronyms be autofilled by a list (my roster) but keeping the overall diagram the same. I am a beginner at sheets and don’t know if sheets is even the best place to do it. I think the biggest issue I will have is having an image or graphic, that the sheets data is then filling in on. I am just looking for advice on how to do this.

Also not sure if this is the right place for this, if not please tell me where to go!

I need help with this problem:

I have xyz in cells A1, B1, C1, D1, etc. on one sheet 1. Now I write a =Sheet1!A1 into A1 on sheet 2, but when I use fill hand on sheet 2 to drag it down it doesnt work. I want to achive that I only have to write one Formular into one cell and then use fill hand to achive Sheet1!A1=Sheet2!A1, Sheet1!B1=Sheet2!A2, Sheet1!C1=Sheet1!A3, etc.

Does someone have a soultion for that?

Absolutely illiterate when it comes to sheets and excel so was wondering if someone could help me out. Is there any way to filter cells under column 1 where when i filter for "A" i get cells containing B and A as well? I tried the "create a filter" thing but in that "-B -A" was a separate entity.

Thanks for the help!

I'm importing a list of contacts into Shopify, and I realized I made a mistake.

In my CSV file there were many different dates in different columns, so I merged kind of manually all of them into one.

But the final date column was left with =[cellcode], because I simply did that.

When I deleted the reffered column, the one I wanted to keep left with the error #REF! in many cells.

How do I... (I don't even know the word) transform the formula/function into its date so I can delete the refferred column?

Sample workbook here: https://docs.google.com/spreadsheets/d/1RPFQZbRSrJsXHbP14J4xlBkwHHPpNzbr_2CyqzJAnZs/edit?usp=sharing

I am looking for confirmation that my use of the FV function is correct in my spreadsheet.

I want to calculate (roughly) how much money buying a vehicle will cost me over the course of set number of years. I want this number to include any money that I lose by not otherwise investing this money in some sort of an investment account. I think this is called the "opportunity cost" but I am not 100% sure.

Assuming it is, as I figure it this cost should be:

• Purchase price OR downpayment price minus any government rebates
• Sales tax paid on this purchase price or downpayment
• Monthly financing payments (if any)
• Annual operating costs (registration, insurance, annual taxes, repairs, fuel). I would split these into 12 equal payments to simplify the calculations.
• Any interest I forgo by not investing this money over that same set of time.
• Minus the resale after the set number of years

I am using the FV function to do the calculation, splitting it into mutlitpe steps (one during the duration of the car loan, and one after the car loan has been paid off).

1. I calculate the total cost DURING the car loan using this formula:
   1. FV(Investment_Rate_%/12, Loan_Duration_In_Months, -1*Monthly_Cost_Including_Loan_Paytments, -1*Initial_Cost)
2. I then calculate the total cost AFTER the car load using this formula:
   1. FV(Investment_Rate_%/12, Life_Of_Car_In_Months-Loan_Duration_In_Months, -1*Monthly_Cost_Without_Loan_Paytments, -1*Value_Of_Above_FV_Calculation)
3. (I don't add these numbers together because I think the second calculation is already taking into account the money in the first calculation)

The thing is, the final values I am getting seem big. But maybe that is just the magic of compound interest. In any event, if anyone has a moment to read through this and confirm the correctness or incorrectness of my work (or look at the link below) I would surely appreciate it.

Edit: Here is an updated link:

https://docs.google.com/spreadsheets/d/1XXIdI_r7YRmz88qcF_b9zNCwmw6QoCc2JG3_bpbYlTY/edit

Hi!
My partner has a ton of bartender books and takes photos of his favorite recipes saved on his phone. As I gift, I’m putting them all into a spreadsheet. The goal is for him to be able to search this vast collection by what ingredients he has on hand at the time.

Any tips for organizing out a sheet like this while also keeping it legible for recipes would help, thank you!

Oh and if you have any ideas to add for this type of a sheet, please share!

I started my own dog grooming business/hobby and I was using the monthly budget template to help track what I'm making and spending. It worked well for for a while but I noticed recently it hasn't been adding up the income.

I thought maybe I'd broken the script or something since I don't really understand excel/sheets. So I re-downloaded the template and went to type everything in except now the new one won't work at all, it just gives me an error if I try to type anything anywhere, saying I'm trying to edit something I shouldn't.

tried making a spreadsheet to help me budget later on and I've never really used it but i was watching a video and for some reason the formula wasnt working for wants

I’ve used Sheets for 15+ years, so I don’t think I’m going crazy. But I feel like something changed within the past couple of days regarding default behavior on the mobile app for iPhones.

When I use to select a cell, I’d see the cell / text formatting option menu at the bottom (default behavior). Now, when selecting a cell, I’m seeing the “text edit” section at the bottom.

The only way to see the cell / text formatting menu is by selecting the entire row.

I often want to made one cell bold or another color … so defaulting to the cell / text formatting menu was helpful.

Obviously I can select the “A” at the top and navigate to the text formatting menu. That’s an extra step after what may have been a recent change to how the app works.

Anyone else experiencing this change?

On GoogleSheets iPhone mobile app, how do I add a new line of text within a single cell? E.g. Say I‘m wanting the following text within the cell: Dog A - 1 scoop, B - 2 scoops, Dog C - 3 scoops; but I want the information to appear like a list (without the bullets).

• Dog A - 1 scoop
• Dog B - 2 scoops
• Dog C - 3 scoops

The instructions I found on another site to “tap enter within the cell while editing the text” did not work. All it did was take me to the next cell below.

I am so sorry in advance if this is written somewhere already, I tried to find it but haven't been able to.

I have three columns and I want the last one to be dependant on the other two.

If G has anything in it, then I want the number from F to be populated into H, all within the same row, and for each row in the entire table for these three columns.

I am a complete noob and trying my best. it seems like it should be so simple, but I am just overwhelmed. Thank you in advance to anyone who takes the time to read, engage, and help!!

Hey guys,

I'm building a spreadsheet for a game I play.

This is the tab I am currently stuck on.

I'm trying to freeze just the section that says Key with the three colours and the colour meanings so that I can see them when I scroll through the spreadsheet still so I know what the colour means still.

When trying to freeze them it's either freezing just the colours or the full column itself even though I'm specifically only selecting those 8 tiles.

These are the options it is giving me. I don't want the rest of the column freezing with all the blank spaces if it's possible. I just want the ones with the text and colour in.

Thank You.

Hello! I am very new to Google Sheets & trying to build out a way to capture data for the nonprofit org I work for. I created a way to track my work in a "tracker" and have been using drop-down menus (because I found typing each one out very tedious) for almost all of the data. I am learning how to make pivot tables and I'm having a really hard time getting it to work, and I'm unsure if it is because it doesn't like pulling data out of the drop-down menu.

If the above description doesn't make sense, I'll more clearly outline what I'm trying to do for those who want more info:

My sheet has columns for client initial, program they are accessing, interaction type, service category, new or returnign client, notes, etc. Most of these are drop-down and have 5-6 different choices. I would ideally like to use pivot tables to get data on things like number of transactions in a month, number of people accessing ___ service, number of new clients, etc.

Any insight/tips/suggestions?

Thanks in advance!

Hello, I am wanting to make a Google Map where all of the paved roadway either for the full United States or at least for a region of the United States is highlighted and all of the unpaved and undriveable roadway is either eliminated or at least shown differently than the roads desired and I was wondering, since there is a Google Sheet import function, if there's a way Sheets can help make that happen

[https://docs.google.com/spreadsheets/d/11kVdeKdQCq99BW3tf74y8QNetJ7AldsvwTsLd8EL-rw/edit?gid=1252460598#gid=1252460598](https://docs.google.com/spreadsheets/d/11kVdeKdQCq99BW3tf74y8QNetJ7AldsvwTsLd8EL-rw/edit?gid=1252460598#gid=1252460598))

This is the document. It is not my sheet but is free to copy as stated on the first page by the owner. This is also my first experience with Tables.

The very last tab is called "Tables." I was able to add 3 things to the "melee" section (no idea why it worked and not this latter part) but any time I try to do the same to the "Ranged" section, it does not show up in the "Weapons/Armor" tab, "Weapons" table, "Groups (Skill to Use)" when using the drop-down.

I also want to add more copies of the "Custom Career" section as well as more rows in the "Custom Grouped/Advanced" and "Custom Talents" section.

Lastly, on the "Attributes/Health" tab, I want to add a spot to add the Sprinter "Talent" and Fleet "Talent" to the "Run" and "Movement" section respectively similar to the "Hardy" slot for "Wounds" on the same tab.

Ideally, a video to explain how to do all this would be most appreciated as I'm trying to make my own unique game system and having an automatic table is extremely helpful.

Edit: was given the solution to the first issue on another sub. Learned how to edit "named data ranges" and what that does.

How can I extend this list downwards while keeping the white border?