r/spreadsheets

I would need a sheet for project statueses (in-progress, paused, etc.) and another sheet for to do listing things i need to do for such projects as well as any additional sheets this could need, such as one for things to buy in each project. I've been trying to think up something like this for a while--with little to no success--so any ideas would be welcome!

I’ve been using Sheets a lot more recently and keep running into small things that don’t seem like much at first, but end up saving a ton of time once you actually use them regularly.

Curious what others have come across — could be a formula, a setup, a workaround, or even just a small habit that stuck.

Anything that made you think “why wasn’t I doing this sooner?”

I can’t figure out how to copy this without transferring numbers and calculations I want the same thing copy and pasted on the same page and start the math over again

I imported some data into Google Sheets and a bunch of rows are blank in one column because the value only appears once for each group.

Right now I’m basically fixing it manually and it’s taking forever.

Example:

Category

Shoes

(blank)

(blank)

Hoodies

(blank)

I just want the blank cells to automatically use the last value above them.

Feels like there should be a really easy way to do this but I can’t find one.

I have a project that requires cleaning up a large Excel spreadsheet and doing some basic analysis.

Tasks include removing duplicates, formatting data, creating simple formulas, and generating a summary report.

Details:

• File type: Excel (.xlsx)
• Rows: ~15,000
• Timeline: 2–3 days
• Payment: $50 (negotiable)

Please DM me if you’re experienced and can deliver quality work on time.

Open to discussing details before starting.

Thanks!