Is there a way to specify which rows I want in a metrics sheet for widgets?
Mary Vogt
✭✭✭✭✭
Hi,
I have a metrics page that links to a sheet with data on it. The metrics I am interested in are attached. On the dashboard, we are using a donut graph to show all four categories: Red, Green, Yellow, Gray. But now I want to create another one that only shows Yellow and Grey metrics (e.g., 5 hour training completed percentage, and 5 hour training not completed percentage).
Is there a way to do this without having to create a new metrics page? Thank you for any help.
Tags:
Answers
-
You can replicate the metrics using cell linking into a new section of the sheet. Just retype "Yellow" and "Gray", then use a basic cell reference to the current data counts so that you can ensure the two numbers actually match.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!