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?
Help Article Resources
Check out the Formula Handbook template!