Sheet Summary Field: COUNTIFS formula with multiple OR

Lisa Matthews2
Lisa Matthews2 ✭✭✭✭

Hello,

Looking for some help with a formula I would like to add as a sheet summary field for a report which will be used in a dashboard chart. I have used this formula before with other sheets (different columns and values) but it is not working in this sheet. This is the formula which I cannot figure out how to fix:

sheet summary field: Count Open IT Issues

=COUNTIFS([Status Text]:[Status Text], OR (@cell= "Active", @cell = "Triage"), [Resolution]: [Resolution], OR (@cell= "Data", @cell= "Bug", @cell= "Incident", @cell= "Access"))

I will be creating this chart. In this one example, I need to isolate the open IT Issues. So the formula should look at the Status column as well as the Resolution Type column to determine whether to count the row or not.


Please help! Thanks in advance.

--Lisa

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer βœ“

    Hi @Lisa Matthews2

    It looks like you might have an extra space after each OR but before its opening parentheses...ex:

    OR (

    instead of

    OR(

    Can you check to make sure that there are no gaps between a function and its parentheses?

    =COUNTIFS([Status Text]:[Status Text], OR(@cell= "Active", @cell = "Triage"), [Resolution]: [Resolution], OR(@cell= "Data", @cell= "Bug", @cell= "Incident", @cell= "Access"))


    Paul, let me know if I'm missing something else πŸ˜‰

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!