My spreadsheet formulas broke and I spent 3 hours fixing them last night

I was trying to track my grocery spending for the month and my sum totals just stopped working. Turns out I had a hidden row messing everything up. Anyone else have a simple budget tracker go sideways like that?

3 comments

3 Comments

torres.grant22d ago

Yeah the filter thing is a real trap. I've done that with a budget sheet where I filtered out "paid" expenses but then my total sum formula still counted the hidden rows. The numbers looked way off. How do you even check for that besides just turning off all filters and scrolling?

felix_black24d ago

Hidden rows are the worst. I swear they cause half my spreadsheet problems. Once had a filter on that hid some data and my charts looked insane for a week.

rubyshah24d ago

Ever have a formula break because you typed a number instead of a date? My whole project timeline got messed up that way once. Took me forever to spot it.