INDEX MATCH Formula Problems PROBLEM SOLVED

Hello,

I'm new to Smartsheets and not sure if INDEX MATCH is the correct formula.

I am trying to auto-populate the System ID based on the answer in System Name from a reference table in another sheet. I get an UNPARSEABLE error with the following formula in System ID column:

=INDEX({Leak Details 2023 Reference Tables Range 1}, MATCH({Leak Details 2023 Reference Tables Range 3}@row, [System Name]@row, 0))

Main working sheet

Separate sheet with multiple tables

I will be using the same type of "identification" for other columns in the main sheet as well. Your help is greatly appreciated!

Thank you,

Kerry

Find more posts tagged with

Accepted answers

All comments

CentricKerry

I figured it out!! I had two or the ranges switched.

Ryan Sides

Glad you got it worked out!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.