How to pull multiple project plan sheets into one report dashboard that shows overall progress?
I need help creating a report and/or dashboard that shows the overall stats of all of our sheets. We create a sheet for each new integration deal we have and I am looking for a way to easily display our overall progression but I am at a loss of where to begin. Each sheet has approximately 800 rows so a lot of data!
Answers
-
Hi @FRP Acct Intg,
I would suggest you create a Metric Sheet that accompanies each sheet. This Metric Sheet would house any and all relevant summary data you are looking to gather from the 800 rows that would cleanly be displayed on a dashboard.
Travis C, PMP
Smartsheet Leader with 5+ years of SS experience
Let's connect: LinkedIn - Travis C.
If my answer was sufficient, pleaseupvote and mark my response as answered.
-
Any idea on how I can get direction on how to do this? I have no idea what a Metric Sheet is. Thanks MedaUser!
-
Hello @FRP Acct Intg!
Here is a link to a helpful presentation that discusses Metric Sheets: UE10_Adv Dash Next Level_JShimek.pdf
And a link to a YouTube video that walks you through the process of creating a metric sheet:
Smartsheet Tutorial: How to Create a Metrics Sheet in Smartsheet
Hope this helps!
Michelle Cullen
