how to omit 0 in graphs in a dashboard for a cleaner look
Options
hi! I want my graph to only show values greater than 0. I've tried cleaning up my rows by adding a formula to leave cells blank if the value is zero. however, when I add the graph to my dashboard all values are showing and it looks really messy.
this graph comes from different values but just to get a visual
Answers
-
Try creating a report from the metrics that is filtered to only show rows where the value is greater than zero. Then build out your chart from the report.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!