B
2

My spreadsheet formula fight took 4 hours to fix a $2.37 mistake

I was trying to track my grocery spending in a Google Sheet and had a cell that kept showing my coffee budget as $2.37 over, but I knew I only bought one bag. Turns out I had a hidden row from last month that was adding in an old charge, and I had to manually check every single line item to find it. Has anyone else wasted half a day because of one tiny, hidden number messing up their whole budget?
3 comments

Log in to join the discussion

Log In
3 Comments
the_amy
the_amy13d ago
Check for merged cells next time.
8
the_lee
the_lee13d ago
Ugh, hidden rows are the worst.
6
ellis.leo
ellis.leo13d ago
You hid 200 rows in a single sheet?
-1