Formula to count # of certain status symbol

TaliRXM

Hello,

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?

Thanks,

Tali 

Peggy Parchert

Hello @TaliRXM

Try =COUNTIF(Status@row, "Green")

Or are you trying to do this from Sheet Summary? If you are using Sheet Summary, try this:

=COUNTIF(Status:Status, "Green")

Hope this help!

Peggy

Peggy Parchert

Hello @TaliRXM

Try =COUNTIF(Status@row, "Green")

Or are you trying to do this from Sheet Summary? If you are using Sheet Summary, try this:

=COUNTIF(Status:Status, "Green")

Hope this help!

Peggy

TaliRXM

Hi Peggy,

Yes, I was trying to do this from 'Sheet Summary' and now the 2nd formula above =COUNTIF(Status:Status, "Green"), worked. I see that I had the brackets positioned wrong.

Just for my knowledge, the first formula =COUNTIF(Status@row, "Green") will work if I do it in the sheet itself?

Thanks much for your fast reply and help!

Tali

Peggy Parchert

@TaliRXM

Wonderful! Yes - the first formula would work if it was in a column in the sheet itself.

Happy to help!

Peggy

TaliRXM

THANK YOU!