Tried to automate my weekly report with a spreadsheet formula and it backfired in front of my boss
Last Thursday I set up a formula to auto-pull numbers from three tabs into my weekly report because I was sick of copying cells by hand. It ran fine when I tested it, but when I demoed it in our team meeting it grabbed data from an old tab and doubled the sales figure for the Northeast region. My manager looked at the chart, paused, and asked why we suddenly sold $480k in Portland. I spent the rest of the day rebuilding the sheet the slow way. How do you all double check formulas before showing them to a manager?