Is there a way to specify which rows I want in a metrics sheet for widgets?



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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!