How can I access the name of a sheet in a formula?
we have the convention where particular series of sheets start with "YY_XXX9999_etc" where the YY is a overall Project code and the XXX9999 is a code for the location where tasks will be done. I want to extract the code from the sheet name and use it to populate the sheet with additional information from a master list of locations. Is this possible? e.g. =MID({SheetName}, 2, 7)
Answers
-
You would need to leverage the API or the premium add-on Bridge to accomplish this.
Otherwise you would need to manually enter it (probably in a sheet summary field) and then reference that, but you would have to remember to manually update the field if the sheet name changes at any point.
-
"You would need to leverage the API" - how do I do that without Bridge?
-
How are you creating these sheets? Are you potentially using Control Center?
-
Some yes, others no
-
For the ones using Control Center, if you are entering that middle portion into your intake sheet, you can use Control Center to push that value to the metadata sheet for each project and then pull it into your calc sheets from there.
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!