IfError returns "incorrect argument"

Hi, I am trying to find values that exist between two Smartsheets. When it does, I should get a checkbox, and when it doesn't, I would like the checkbox to be unchecked.

If I use:

=IF(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0)

I get "#No Match" when a value doesn't exists between the two sheets.

And if I try:

=IFError(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0)

I get "#Incorrect Argument."

Can someone help point me in the right direction? Thanks!

Find more posts tagged with

Sheets

Formulas

Accepted answers

KPH

Hi @Peggy S.

You are missing an argument from your formula. You need to include what you want the formula to return if there is an error. This part in bold means return 0 if there is an error. Which in turn means uncheck the checkbox.

=IFERROR(IF(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0), 0)

All comments

KPH

Hi @Peggy S.

=IFERROR(IF(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0), 0)

Peggy S.

I knew I was missing something. Thank you so much! It worked and got me exactly what I was looking for.

KPH

Glad I could help @Peggy S.

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.