IFERROR Statement with COUNTIFS, AND, OR.

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!