Indexing across sheets with the same name

markj1
βββ
Is there a way to Index or search all sheets named Project Metadata? I want to populate a sheet using the project number at the top level.
Tags:
Answers
-
If all of the project metadata sheets have a unique ID somewhere in the columns, you can reference them all in a new sheet via index/match based on that ID
Sincerely,
Jacob Stey
-
Thank you for the response. Can you help clarify or give an example?
I am trying to create what you're saying but I want to make sure I am following correctly.
When I originally create these project folders will I need to add references to this new sheet?
-
-
I just watched Smartsheet Control Center | Smartsheet and that is definitely what I am trying to explain. Thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives