Formula question :)

I am trying to pull content from 2 existing sheets into a new sheet that will have additional manually editable columns. The formula that I am currently playing with isn't work, but looks like this:

=IFERROR(INDEX({Type}, MATCH([EventID#]@row, {EventID}, 0)), INDEX({Event Location}, MATCH([EventID#]@row, {NOEventID}, 0))

Basically I am working off of autopopulating some of the cells in the row based off of the eventID's from 2 different sheets.

Thank you in advance!

Find more posts tagged with

Formulas

Accepted answers

All comments

Kelly Moore

Hey @Whitney Davis

When you say the above formula isn't working, please describe. Is it not returning the expected data or are you receiving an error? IF you are receiving an error, what error? Is the IFERROR there to redirect in the event of NoMATCH?

Kelly

Whitney Davis

Hi @Kelly Moore ,

I am getting an error message with that formula. "#UNPARSEABLE" is the error message I am getting. I am trying to build a sheet that pulls from a primary sheet and then if there is no data on the primarty sheet to pull from the secondary.

Thank you for your help, I am fairly new at SmartSheet.

Kelly Moore

Hey Whitney

You're missing the last parenthesis to close the IFERROR. Look at your last parenthesis in your current formula. My guess is it is pink instead of blue. Add one more

=IFERROR(INDEX({Type}, MATCH([EventID#]@row, {EventID}, 0)), INDEX({Event Location}, MATCH([EventID#]@row, {NOEventID}, 0)))

Does this work for you?

Kelly

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.