The inventory spreadsheet that cost us 3 days to fix

I spent 12 hours building what I thought was a perfect inventory tracker in Excel, only to realize every formula broke when I added a new category. Took another full Tuesday just to rebuild it with proper table structures. Anyone else waste a whole week on a system that should have taken an afternoon?

2 comments

2 Comments

haydenp9518d agoMost Upvoted

Oh man, I feel your pain so hard. I did the same thing with a client's order tracker - spent a whole weekend on it, then broke everything by adding a simple "shipping status" column. What finally saved me was learning to use Excel Tables (Ctrl+T shortcut) and named ranges. That way when I added new categories, the formulas just automatically expanded instead of throwing errors. Also switched to using SUMIFS instead of VLOOKUP, way more flexible.

james53318d ago

Gonna have to push back a little here @haydenp95 - Tables and SUMIFS are overkill for most simple trackers and can actually make things harder to audit when you're troubleshooting. Plain old ranges and INDEX/MATCH have never let me down, just gotta be careful with your column locking.