Count If - Status Symbols

Maria R

I am trying to count the number of cells that have Status (Green) in my status column i am using a dropdown with Symbols Green, red, yellow.

I am trying countif but don't know how to specify the 'symbol' green.

Any ideas?

Mike Wilday

You can do a count if statement counting the text "green", "red" or "yellow" -- as these are what the symbols put in the value. Smartsheets interprets them as symbols, but those are the specific terms to use in a formula. 

This smartsheet article might be of assistance: https://www.smartsheet.com/blog/support-tip-automate-RYG-balls

Alex Xu

Maria,

To do this, your equation should look something similar to this:

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

This should give you the correct amount of Green Status orbs.