How would I count non started cells

I'm trying to count the number of non-resolved cells that use a star symbol, filled in resolved, unresolved not filled. Want to exclude blank cells.

I tried:

=COUNTIFS(Resolved:Resolved, IF(NOT(ISBLANK(Resolved:Resolved)), 1, 0))



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!