Do not display rows with null/zero values on dashboard



So, I read a few questions on the community but didn't get answer to my question.

I have a smartsheet with a lot of names on primary column and there are values assigned in different columns in front of these names. Many of these are 0 or null values. I know how to use IF function to have null values instead of 0 values.

But in dashboard, when I display all names, I want only those names to appear that have non-zero values in it. How do I hide names with 0/null values?

How can I do that?


Neetu Chopra


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!