Metrics: Using the metrics template and metadata
I have the following setup:
- An Individual Project (Individual)
- A Dashboard Rolling Up Projects Assigned to an Individual (Program)
- A Dashboard Rolling Up All Projects (Portfolio)
- Each of the Individual, Program, and Portfolio has a metadata report and a metrics report
Problem: I have to manually link the portfolio, program, and individual projects together in metadata to get the Metrics feature to calculate unique aspects for program and portfolio level rollups. If the metadata does not have data linked from portfolio in the program metadata, the metrics (project count, RYG, active, pending) won't populate.
Success Criteria: Eliminate the manual linking of metadata so that if key criteria like project manager exists it automatically populates in the appropriate persons metadata file and produces the outputs I'm looking for in the metrics file that then populates the dashboard.
Answers
-
Hi @Eddie JR
I hope you're well and safe!
A solution that would be perfect for this use case is the premium add-on, Control Center.
Is that an option?
More info:
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives