16
My spreadsheet formula fix turned into a two hour project
I was trying to get my grocery budget to auto-calculate a 15% savings goal in Google Sheets. The formula looked right, but it kept showing zero. I had to dig through old forum posts and finally found out I was using the wrong cell reference type. Has anyone else had a simple budget fix blow up like that?
3 comments
Log in to join the discussion
Log In3 Comments
grace_kelly4519d ago
What cell reference got you?
6
Oh man, does that ever hit close to home. I once spent an entire evening trying to figure out why a simple sum formula wouldn't work, only to realize I had typed "SUMM" instead of "SUM". I felt like a genius after all that. Spreadsheets have a way of making you feel both smart and incredibly dumb in the same hour.
5
ray61319d ago
Been there with the typing errors... my personal hell was spending two days debugging a script because I kept writing "lenght" instead of "length". The computer just sat there judging me silently. It's crazy how a single wrong letter can bring everything to a halt. You finally spot it and the relief is huge, but also mixed with pure annoyance at yourself.
3