r/sheets

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.

Hey guys,

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

https://preview.redd.it/3rq9t8qgr0jh1.png?width=2313&format=png&auto=webp&s=e8debc79cdb2dada5ff9587186a3fd5d70612957

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.

https://preview.redd.it/bt9hodrur0jh1.png?width=579&format=png&auto=webp&s=3bc0797f507966066facd41f2a36f1426f85e811

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.

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!!

https://preview.redd.it/2mh3c7xbp8jh1.png?width=234&format=png&auto=webp&s=86d17cc904d41214e3a58b7dd50e2fcd820c8b04

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