IFERROR and Nested IF Statement
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
Best Answer
-
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)
Answers
-
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)
-
Thank you John, that worked. So it was the OR I was missing!
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!