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.
Answers
-
Hi @tpokrywka
The name that appears under sheet reference name is the name that has already been assigned to the highlighted column in that sheet. So, it looks like, in the example you shared, someone has given the "Position" column in the "Las Vegas (Support)" sheet the name "Centennial (Support and Home) Range 1" (Possibly when the sheet had a different name). To make QC easier, you can edit the names in this window, or by right clicking on the sheet and selecting manage references.
-
Dang. Ok. Wish the named range changed with the sheet name when you change the sheet name. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!