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
Best Answer
-
@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.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
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
If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.
Thanks!
Nick Stafford
-
-
@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.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 358 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!