IFERROR and Nested IF Statement

Hannah H

Hello,

I would like to incorporate an IFERROR into my IF statement, to weed out the pesky #NO MATCH error.

I'm using the formula on a checkbox column and I want it to return a check if the Audition Status column contains Reject or On Hold and be unchecked if the Audition Status column contains anything else (Awaiting Review, Proceed to Hire, Revisions Requested, Revisions Received, #NO MATCH). I am using an INDEX/MATCH on the Audition Status column to draw in data from another sheet.

Here is my working IF statement =IF([Audition Status]@row = "reject", 1, IF([Audition Status]@row = "on hold", 1, 0))

Here is my attempt at adding in the IFERROR

=IFERROR(IF([Audition Status]@row = "reject", 1, IF([Audition Status]@row = "on hold", 1, 0), 0))

Where am I going awry?

Thanks!

Hannah

John Jonassen

After playing with it, you shouldn't need the IFERROR, but I've included it just in case. Give this formula a try:

=IFERROR(IF(OR([Audition Status]@row = "REJECT", [Audition Status]@row = "ON HOLD"), 1, 0), 0)

John Jonassen

After playing with it, you shouldn't need the IFERROR, but I've included it just in case. Give this formula a try:

=IFERROR(IF(OR([Audition Status]@row = "REJECT", [Audition Status]@row = "ON HOLD"), 1, 0), 0)

Hannah H

https://community.smartsheet.com/discussion/comment/265040#Comment_265040

Thank you John, that worked. So it was the OR I was missing!

John Jonassen

https://community.smartsheet.com/discussion/comment/265041#Comment_265041

The original formula was just a little more restrictive. In other words, you would have to provide a nested IF for each status that you have set up in your process. This just groups the statuses you want and gives a pass on the rest.