Formula for counting if cell has RYG symbol

I need to count the total number of cells within a column if they have either Red, Yellow, or Green symbol. We also have the grey symbol, but that should not be counted. I am using this as a way to indicate the total number of active projects in our dashboard. I have tried =COUNTIF(Status:Status, "Green") OR(Status:Status, "Yellow") OR(Status:Status, "Red")

Best Answer


  • jessica.smith
    jessica.smith ✭✭✭✭✭
    Answer ✓


    Try =COUNTIF(Status:Status, OR(@cell = "Green", @cell = "Red", @cell = "Yellow"))

  • JamesB
    JamesB ✭✭✭✭✭✭
    edited 03/13/24

    @smartsheetuserucb1 If you want the individual count of each one, then you would need three separate formulas in three different cells.

    =COUNTIF(Status:Status, "Green")

    =COUNTIF(Status:Status, "Yellow")

    =COUNTIF(Status:Status, "Red")

    If you want it in one cell, then try something like this.

    ="Green "+COUNTIF(Status:Status, "Green")+", Yellow "+COUNTIF(Status:Status, "Yellow")+", Red "+COUNTIF(Status:Status, "Red")

    This formula should display a response Green X, Yellow X, Red X

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!