Dashboard Charts- Remove Data without Value

Hi All,

I've created a dash and have a chart where I'd like to display data that does not include descriptions with zero values. Below details the dash/chart as it currently stands.

I would like to get rid of the lines without a value (remove Abduction Pillow, Bed alarm, etc.).

Here are my metrics- can't seem to figure this out. This would be extremely useful in multiple applications so any help is greatly appreciated! Thanks!

PS I did find this from Paul Newcome in another post, but cannot figure out how to apply it:

"Insert another column and use a formula such as

=IF([Column With Count]@row <> "", [Column With Label]@row)

Then you can reference this column in your chart."


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!