Formula to remove zero on metric sheet


Hello - I am using a metric sheet to pull together a Dashboard of information. I am pulling from a larger sheet into the metric sheet and then importing the data into a Dashboard either as a chart or metric.

The data I am pulling changes every month and I want to simply total what is being processed each month. Some months there are zero of a particular item and I don't want to record those in the Dashboard. I tried filter in the metric sheet, but that doesn't translate to the Dashboard.

This is the formula I am using =COUNTIFS({Status2}, Status@row, {Deliverables}, [Primary Column]@row)

Any guidance would be so appreciated!!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!