Count # of Open issues in another sheet

rlakin52911
rlakin52911 ✭✭✭
edited 12/09/19 in Formulas and Functions

Trying to count the total number of "open" and "Waiting" issues in a another sheet

=COUNTIF({Sheet - RAID Log Range 1} Status:Status, "Open")+COUNTIF (Status:Status, "Waiting")

Hitting a wall, getting an error. Anyone have some guidance?

Comments

  • Hi,

     

    if {Sheet - RAID Log Range 1} represents the column Status you want to count in, your formula should look more like this :

     

    =COUNTIF({Sheet - RAID Log Range 1}, "Open")+COUNTIF ({Sheet - RAID Log Range 1}, "Waiting")

     

    Does this help?

     

    Best Regards,

     

    Paul.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You could also use =COUNTIFS({Sheet - RAID Log Range 1}, "Open", {Sheet - RAID Log Range 1}, "Waiting")

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!