Metrics Widget - Summarize from Many Sheets in a Workspace
I want to add a Metric widget to a Dashboard that totals the number of projects that I have in another workspace.
Each schedule (sheet) in that workspace has standard summary fields that I use in Reporting. When a new schedule is dropped into the workspace, it is automatically picked up by all the reports that look at that workspace, no additional work is needed.
However, I want to create a Metric Widget on certain characteristics of the projects for a Dashboard (say, # of Projects by Department, or Projects at Risk). I have this info in the Summary sheet info for each schedule. Now, the Metric Widget only looks at Sheets but from what I can tell, there's not a way to summarize the fields in a workspace automatically when something gets added to the workspace via a new schedule (sheet). Is there another way to do this?
To try to state this more clearly, I want to create a Metrics Widget that looks at sheets in workspace and totals information on anything in the workspace without having to go in a manually change the formula each time a sheet is added.
Answers
-
I would suggest sheet summary fields to house things like Department, at risk, etc. on each sheet. Then you can use a report to pull in all of the appropriate summary fields and then use grouping and summary in the report itself to get your totals. While you can't reference a report in a metrics widget, you can create a basic chart from the report.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!