Formula cells are breaking because the cells are linking to one another inside the sheet
I built out a metric sheet and use sheet references within the cell formula. It was all linking and working correctly. I noticed last week that one of the formulas was not correctly calculating the total as it was previously. When I try to fix the formula and reference the correct column from the other sheet it breaks EVERY formula on the sheet.
Nothing had changed and the references from the other sheet hadn't changed.
How do I troubleshoot this so I don't have to write the formulas all over again? How can I tell why changing a formula on one part of my sheet is breaking another one?
Help Article Resources
Check out the Formula Handbook template!