IFERROR Statement with COUNTIFS, AND, OR.

Hi Community.

I want to add an IFERROR statement to a formula on a Calculations Template sheet.

This one is fine: =IFERROR(COUNTIF({Status Range 1}, ="Submitted") + COUNTIF({Status Range 1}, ="Rejected - Further Detail required"), 0)

I am struggling to get it to work in this Calc: =COUNTIFS({Tracker Range 3}, "Red", {Status Range 1}, AND(OR(@cell = "Submitted", @cell = "Rejected - Further Detail required")))

Where should the statement fit in this formula. The formula itself without the IFERROR function works fine. Help gratefully received.

Best Answer

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    If the base formula works fine (although I'm not sure how that AND/OR combo is supposed to be working), then you would add the IFERROR the same way you have it in your first formula.

    =IFERROR(original_formula, 0)

  • Thanks Paul.

    I may have over complicated my formula, but it seems to work. I am just saying when the 'Priority column (Tracker Range 3) is ragged Red, count how many rows in the 'Status' column (Status range 1) show as "Submitted" or "Rejected - Further Detail required" but also include the IF ERROR.

    Please let me know if this can be simplified.

    Thanks again.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Yeah. You would just use the IFERROR the same way you did in your first formula, and you don't need the AND function at all. Just the OR statement.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!