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.