PMO - Index - Search across several folders
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.
Best Answers
-
Do you have a question or a challenge here?
-
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.
-
No, I am not.
I just watched Smartsheet Control Center | Smartsheet and that is definitely what I am trying to explain. Thank you.
-
Without Control Center you are looking at a very manual process.
Answers
-
Do you have a question or a challenge here?
-
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.
-
Are you using control center?
-
No, I am not.
I just watched Smartsheet Control Center | Smartsheet and that is definitely what I am trying to explain. Thank you.
-
Without Control Center you are looking at a very manual process.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives