Formula

Hi
I am changing the formula below but it doesnt work as expected. Can someone show me the correct way. Thanks

From:
=IF(OR([Item Status]@row = "(LTB)", [Item Status]@row = "(BB)"), "esh@gmail.com", IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([MSI / EMS Site]@row, {Site1}, 0)), "")))

To:

=IF(OR([Item Status]@row = "(LTB)", [Item Status]@row = "(BB)"), "esh@gmail.com",IF(OR([Item Status]@row = "(LTB)", [Item Status]@row = "(BB)"),"anurz@gmail.com", IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([MSI / EMS Site]@row, {Site1}, 0)), "")))

The scenario that need to be add in just additional name for the LTB and BB which is anurz@gmail.com

Find more posts tagged with

Accepted answers

Mark.poole

@HZAR,

@NickStaffordPM is right in how the iff statement works. The easiest way to get this to would would be to put both emails in another cell and reference that cell when the criteria is true. Rather you do it in the same sheet or seperate sheets.

Or, you can use automation to assign both people to the cell given the correct criteria.

All comments

NickStaffordPM

So the IF statement will stop running once it sees a correct logical statement, that means that once

OR([Item Status]@row = "(LTB)", [Item Status]@row = "(BB)", "esh@gmail.com"

is true it will input the value esh@gmail.com then STOP, it won't continue to the second

IF(OR([Item Status]@row = "(LTB)", [Item Status]@row = "(BB)"),"anurz@gmail.com"

That would be why your formula is not working for two names.. Let me do some research on some formula options for you / maybe someone from the community can help us out as well

HZAR

Hi @Paul Newcome

Hi @Mark.poole

Can you help to light some guide on this

Mark.poole

@HZAR,

Or, you can use automation to assign both people to the cell given the correct criteria.

HZAR

Hi @Mark.poole and

@NickStaffordPM

Thanks for the input :)

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.