Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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
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.
