Formula issue with #NO MATCH (Using IF and IFERROR)

Hi I have the following formula:

=IF(AND([Attended over 6 months]@row = "Green", Interview@row = "Green", [Referee Check]@row = "Green", [Blue Card Linked]@row = "Yes"), "Yes", IF(OR([Attended over 6 months]@row = "Yellow", Interview@row = "Yellow", [Referee Check]@row = "Yellow", [Blue Card Linked]@row = "Hold"), "Hold", IF(OR([Attended over 6 months]@row = "", Interview@row = "", [Referee Check]@row = "", [Blue Card Linked]@row = ""), "Hold", IF(OR([Attended over 6 months]@row = "Red", Interview@row = "Red", [Referee Check]@row = "Red", [Blue Card Linked]@row = "No"), "No", IF(SOURCE@row = "RF", "Yes")))))

But when the Blue Card Linked column has #NO MATCH my result in my formula column says the same.

i wanted to add the IFERROR to it: =IFERROR([Blue Card Linked]@row, "Hold") but i cant get it to work....the IFERROR works on its own tho...

Is this formula possible?

Find more posts tagged with

Formulas

Accepted answers

David Jasven

You can add the IFERROR function to your formula by replacing:

[Blue Card Linked]@row with: IFERROR([Blue Card Linked]@row, "Hold")

This will cause the formula to return "Hold" if an error occurs when trying to retrieve the value of the [Blue Card Linked] cell. If there is no error, it will return the value of the [Blue Card Linked] cell as usual.

Here is the updated formula with the IFERROR function added:

=IF(AND([Attended over 6 months]@row = "Green", Interview@row = "Green", [Referee Check]@row = "Green", IFERROR([Blue Card Linked]@row, "Hold") = "Yes"), "Yes", IF(OR([Attended over 6 months]@row = "Yellow", Interview@row = "Yellow", [Referee Check]@row = "Yellow", IFERROR([Blue Card Linked]@row, "Hold") = "Hold"), "Hold", IF(OR([Attended over 6 months]@row = "", Interview@row = "", [Referee Check]@row = "", IFERROR([Blue Card Linked]@row, "Hold") = ""), "Hold", IF(OR([Attended over 6 months]@row = "Red", Interview@row = "Red", [Referee Check]@row = "Red", IFERROR([Blue Card Linked]@row, "Hold") = "No"), "No", IF(SOURCE@row = "RF", "Yes")))))

All comments

David Jasven

You can add the IFERROR function to your formula by replacing:

[Blue Card Linked]@row with: IFERROR([Blue Card Linked]@row, "Hold")

Here is the updated formula with the IFERROR function added:

ChristinaP

Perfect thank you so much

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.