Help with formula

Hello,

I have been trying to fix the following formula in Smartsheet but I continue getting the #UNPARSEABLE error message. Can someone help me fix it?

=IFERROR(INDEX({Reference Range 4}, MATCH([Job Level]@row, {Reference Range 5},0)MATCH(Region@row, {Reference Range 6},0)),0)

Reference Sheet:

Find more posts tagged with

Accepted answers

All comments

BullandKhmer

I'm not sure what you are trying to achieve, but one of the below should work:

=IFERROR(INDEX({Reference Range 4}, MATCH([Job Level]@row, {Reference Range 5},0)),INDEX({Reference Range 4},MATCH(Region@row, {Reference Range 6},0)))

=IFERROR(INDEX(COLLECT({Reference Range 4}, [Job Level]@row, {Reference Range 5},Region@row, {Reference Range 6}),1),0)

VaneT

@BullandKhmer Thank you for your help; unfortunately, none of those two formulas worked. I would like the cell to automatically bring up the salary $ based on the region and job level.

For instance, someone at the USA in a 32-Sr Manager level would make $42, 254. But the formula is not working or maybe I am using the wrong formula...

BullandKhmer

Its a simple index collect formula. check out smartsheet formulas and figure it out for yourself.

ker9

Towards the bottom of this is the info you need:

https://community.smartsheet.com/discussion/86632/create-report-with-text-from-multiple-columns-but-stacked-vertically-in-rows

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.