Using #IFERROR to display #NO MATCH as a usable automation

Ty Werven

I am wanting to use a helper column to display a value, lets say "Not Found", based on if the column "Attending? (from RSVP tracker)" is #NO MATCH.

How do I use the #IFERROR command to do this?

I can't seem to get my formula correct. I want to do this to be able to use and automation based on people not having a response to this in another sheet.

Thanks is advance!

jmyzk_cloudsmart_jp

Hi @Ty Werven

Great question!

When using the IFERROR function, think of it like this:

IFERROR(successful_formula, fallback_if_error)

In your case, you're trying to match names from another sheet and return their "Attending?" status. If there's no match (e.g., #NO MATCH), you want to display "Not Found" instead — which is perfect for driving automation.

Here’s a sample formula that does just that:

=IFERROR(INDEX({RSVP_Responses_Sample : Attending?}, MATCH(Name@row , {RSVP_Responses_Sample : Name}, 0)), "Not Found")

What it does:

• MATCH(Name@row , {RSVP_Responses_Sample : Name}, 0) looks for the current row’s name in your RSVP sheet.
• INDEX(..., ...) retrieves the corresponding "Attending?" value.
• If no match is found (which would normally return #NO MATCH), IFERROR replaces it with "Not Found".

https://app.smartsheet.com/b/publish?EQBCT=6c1aeb4e0cec42cc8c826ad3a7a22246

https://app.smartsheet.com/b/publish?EQBCT=409d2e76f0cb489d96fc98eb8d063fad