Explore. Ask. Answer.

or Explore Discussions

countif red text lines

Andreas GevayAndreas Gevay
edited 12/09/19 in Using Smartsheet
01/16/18 Edited 12/09/19

Hi, want to count "at risk" check boxes to present at a dashboard.

 

so I thought fx=COUNTIF(Status2:Status14, "red") works, but it only produces 0 as result

 

Any suggestion

 

Thanks

Comments

  • Kara LumleyKara Lumley Employee

    Hi Andreas,

    If you are using the Red Yellow Green symbol columns, you'll want to use this;

    =COUNTIF([Status]2:[Status]14, "Red") - the capitalization matters.

    If you are using a checkbox column, use this formula:

    =COUNTIF([Status]2:[Status]14, 1)

    Best,

    Kara

     

Sign In or Register to comment.