Looking for a count formula to count total # of Yellow status dots in a column?

Myles Armstrong

I have a status column in a sheet and want to build a metric table in a different sheet. Im trying to count the number of "Yellow" RYG dots in a column.

heyjay

This should help. https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

You can

=COUNTIF([Range:Range],"Yellow")