Handle Changed Column Names Without Breaking Trust
Choose the right response when source columns change in an automated workbook.
The broken refresh The customer success export renamed 'ARR' to 'Annual Recurring Revenue.' The dashboard shows zeros, the macro says success, and the board packet is due in 40 minutes. A fast patch can hide the real contract that broke. Automation triage Source -> Transform -> Validate -> Own Fix the earliest broken contract first, then move downstream. Patch output Fix what looks wrong on screen The fix becomes reusable instead of local. Debug upstream before correcting downstream. 01 Stop 02 Map 03 Guard Decision 1 The output is visibly wrong, but refresh did not throw a useful error.
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in