Cross sheet reference names being scrambled?
I'm building some formulas to reference other sheets, and the names are getting scrambled when I reference various sheets in my build.
For example, I'm setting up a summary sheet pointing to several other sheets. Sheet I'm referencing is Las Vegas (Support). When I click on the sheet to reference it, it grabs another sheet name in my build (seemingly randomly).
The formula seems to be calculating correctly, but this makes my QC process pretty difficult.
Help Article Resources
Check out the Formula Handbook template!