nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Formula giving unparseable error

HZAR

I have the formula below and it give me the unparsable error. The results that i need to achive is if item status as LTB or BB then routed to Adriena regardless which site, but for the rest of the item status, it need to see the site and will vlook from the reference file for he name. Need some expert advise how to fix the formula below

=IF([Item Status]@row="Life Time Buy (LTB),"adrienanurashyiqin.bintizainol@gmail.com",IF([Item Status]@row="Bridge Buy (BB),"adrienanurashyiqin.bintizainol@gmail.com",IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([ EMS Site]@row, {Site1}, 0)), ""))))

Find more posts tagged with

Accepted answers

All comments

Mark.poole

@HZAR

you are missing a couple of "

below I corrected this error

=IF([Item Status]@row="Life Time Buy (LTB)","adrienanurashyiqin.bintizainol@gmail.com",IF([Item Status]@row="Bridge Buy (BB)","adrienanurashyiqin.bintizainol@gmail.com",IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([ EMS Site]@row, {Site1}, 0)), ""))))

HZAR

Hi @Mark.poole

The formula is giving the same error. Not sure if my formula is correct or not. Can you hep me on this

The flow will be

If Item status is LTB or BB and Site ID: All Site ID that available -routed to Adrinna for LEad name

If Item status is not LTB or BB-then vlook up the reference sheet for name based on Site ID for Lead name

If GSP sttaus =Cancel, the levae blank for Lead name

Mark.poole

@HZAR

=IF(OR([Item Status]@row = "Life Time Buy (LTB)", [Item Status]@row = "Bridge Buy (BB)"), "adrienanurashyiqin.bintizainol@gmail.com", IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([EMS Site]@row, {Site1}, 0)), "")))

Check column spelling and spacing.

HZAR

Hi @Mark.poole

The formula is still giving me the same error. Not sure what have cause the issue for this

Mark.poole

if you can. post a screen shot of your sheets

HZAR

Hi @Mark.poole

Attached is the screenshot

Screenshot 2024-06-27 201538.png

reen shot

Screenshot 2024-06-27 201445.png

Mark.poole

@HZAR

would you mind showing me your reference sheets too. if there is any sensitive information create a mock up of it.

HZAR

Hi @Mark.poole

Below is the screenshot from the ref file. Thanks

Screenshot 2024-06-28 231426.png

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.