9
My spreadsheet formula fight took three days to fix a simple mistake
I was trying to track my grocery spending in a Google Sheet and wanted a cell to turn red if I went over my $75 weekly limit. I kept getting errors because I mixed up absolute and relative cell references, something I thought would take 10 minutes. It actually took me three evenings of watching YouTube tutorials and asking my cousin Dave, who works in accounting, before I got it right. Has anyone else had a simple budget tool issue that snowballed into a huge time sink?
3 comments
Log in to join the discussion
Log In3 Comments
harper_foster2d ago
Yeah, carter.casey has a point about learning, but man, three days is a lot of mental energy. I mean, sometimes the win is just having a working tool so you can focus on the actual goal, like not overspending on groceries. That frustration can make you drop the whole budget idea. Maybe the real lesson is knowing when a simple highlight with your own eyeballs is good enough, and when you actually need the fancy formula.
8
Honestly... that sounds like a good use of time to me. Figuring out the formulas yourself means you actually learned how it works, so next time you won't need Dave. If you just used some pre-made app, you'd be stuck the second you wanted to change something. Those three days probably taught you more than a year of just typing numbers into a simple tracker.
6
christopher9432d ago
Yeah, and what if Dave isn't around next time? I mean, you're right that you learn it, but that deep dive only works if you have the free time to burn. Most people just need their budget to work on a Tuesday so they don't order takeout again. The real skill is knowing when to stop tweaking the spreadsheet and just use the thing.
3