Countif yellow or red status symbol

Options
cfischer
cfischer
edited 12/09/19 in Smartsheet Basics

Hi Smartsheets community, 

Does anybody know how to count how many cells have one of two status symbols colors (e.g., either yellow or red)?

 

My current formula is =countif(or(range:range "yellow", range:range "red")). 

 

Any help would be much appreciated!

-cfischer

Comments

  • Dominik Weller
    edited 03/06/18
    Options

    Hi cfischer,

    I don't know if there's a more elegant way to do this, but you could use the following formula:

    =SUM(COUNTIF(range:range; "yellow"); COUNTIF(range:range; "red"))

    Greetings

    PS: Maybe you have to exchange all semicolons ; with commas , ... Since I use german language settings, this may not work for you.

  • L_123
    L_123 ✭✭✭✭✭✭
    edited 03/06/18
    Options

    try count(collect())