Formula to count # of certain status symbol



I have created a column/dropdown with Symbols Green, Red, Yellow, Gray. I'd like to count the number of cells that have Green status in Status column. (in other words, count the # of Green(s) symbol.

In searching Smartsheet community, I saw a reply from 2017 regarding a similar question. The suggestion was to use the following formula:

=COUNTIF([your data range], "Green")

So I used: =COUNTIF([Status:Status], "Green"), but it doesn't work. I get #UNPARSEABLE.

What formula to use to get this count?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!