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.

SteyJ

https://community.smartsheet.com/discussion/111606/indexing-across-sheets-with-the-same-name

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

markj1

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?

Paul Newcome

Are you using control center?

markj1

I just watched Smartsheet Control Center | Smartsheet and that is definitely what I am trying to explain. Thank you.