CountIFS with cross reference sheet with multiple drop down selections


I am trying to get a count of status from cross reference sheet, with multiple dropdown selections in the same column. Here is what I tried and it's giving me wrong number or unparseable error.

=COUNTIFS({Communications Database Status}, "In Progress Compliance", {Communications Database Status}, "In Progress BO")

What am i doing wrong?

Thank you.

Best Answer


  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓


    Use the OR function:

    =COUNTIFS({Communications Database Status}, OR(@cell="In Progress Compliance", @cell= "In Progress BO"))

  • Ari_Ari
    Ari_Ari ✭✭✭

    @Leibel S

    Thank you. As logical as it sounds, I tried OR and at first it gave me unparseable error. At second try it worked. :)

    First try - my formula

    =COUNTIFS({Regulatory Communications Database|Status}, OR (@cell ="In Progress BO", @cell= "Awaiting BO Confirmation"))

    Second try - my formula

    =COUNTIFS({Regulatory Communications Database|Status}, OR(@cell ="In Progress BO", @Cell= "Awaiting BO Confirmation"))

    Strange that SmartSheet would not forgive this syntax error?

  • I'm trying something similar but struggling.

    I don't want a total if either criteria works (which gives me a big number - but rather a count only if both criteria are met.

    I tried to replace OR with AND but it failed.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!