PMO - Index - Search across several folders

markj1

Hello, I would like to Index all of the Project Metadata sheets under the Project Level folder for the Project Number.

I created another sheet at the top level (same as my Project Intake Sheet) called Project Schedule. I want to populate this sheet using the Project Number, similar to the Project Metadata sheet in each project folder. To do this I need to Index/search all Project Metadata sheets in each of these project folders.

Thanks and please let me know if you want screenshots or if you want me to paste the script I have.

Paul Newcome

Do you have a question or a challenge here?

markj1

Hi Paul, I wrote this post then it disappeared so I added another here Indexing across sheets with the same name — Smartsheet Community

This is my first time using the forums so it was a question but might actually be a challenge?.?

I'm trying to populate a project schedule sheet from the project metadata sheets by typing in the project number.

markj1

No, I am not.

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

Paul Newcome

Without Control Center you are looking at a very manual process.

Paul Newcome

Do you have a question or a challenge here?

markj1

Hi Paul, I wrote this post then it disappeared so I added another here Indexing across sheets with the same name — Smartsheet Community

This is my first time using the forums so it was a question but might actually be a challenge?.?

I'm trying to populate a project schedule sheet from the project metadata sheets by typing in the project number.

Paul Newcome

Are you using control center?

markj1

No, I am not.

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

Paul Newcome

Without Control Center you are looking at a very manual process.