How to cound items in a RAID log using the Health Color

Hello -

I would like to reoprt the # of green, vs. yellow vs. red items in my RAID log and use that # in a chart on dashboard.

I use a lot of countifs but I am not sure how to countif the health column. It shows a green dot so I want to count that as one green.

Thanks for any help you can give.

Best Regards,

Christine

Tags:

Best Answer

  • Stacey C
    Stacey C ✭✭✭
    edited 01/30/24 Answer ✓

    Hello, @L_Christine!

    If you are familiar with a COUNTIF function, this should be fairly easy to implement.

    When you select your symbols from the properties menu, if you hover over the item you will get a 'definition' or 'name' for each symbol. As in my screen shot below, the lights are named simply red, yellow or green, but in order to count them, you need to use the following syntax to avoid errors: "Red" , "Yellow" , "Green"

    In the second screenshot you can see an actual example from one of my sheets:

    =COUNTIF([Column4]:[Column4], "Red") //answer = 1//

    I hope this helps! It is super useful! Last screenshot shows how I use it on one of my dashboards. @Stacey C



Answers

  • Stacey C
    Stacey C ✭✭✭
    edited 01/30/24 Answer ✓

    Hello, @L_Christine!

    If you are familiar with a COUNTIF function, this should be fairly easy to implement.

    When you select your symbols from the properties menu, if you hover over the item you will get a 'definition' or 'name' for each symbol. As in my screen shot below, the lights are named simply red, yellow or green, but in order to count them, you need to use the following syntax to avoid errors: "Red" , "Yellow" , "Green"

    In the second screenshot you can see an actual example from one of my sheets:

    =COUNTIF([Column4]:[Column4], "Red") //answer = 1//

    I hope this helps! It is super useful! Last screenshot shows how I use it on one of my dashboards. @Stacey C



  • This is excellent - thank you very much! I made my formula work too!

    Smartsheets is great!

  • Stacey C
    Stacey C ✭✭✭

    Happy to help! Have a great afternoon!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!