If and is not help
Hi Formula Wizards! (Paul if you are listening) I would like to have smartsheet evaluate two columns to see if the contacts are the same in both columns - if they are, I want YES to appear in the helper column - but if either column is blank, I don't want a YES to be returned
in helper column =IF(NOT(ISBLANK(AND([HIRING CONTACT EMAIL]@row)), ([SUBMITTED BY]@row=[HIRING CONTACT EMAIL]), "YES", "))
Thank you so much!
Best Answer
-
Really you only need to check if one is blank. If the other is not blank, then it definitely won't match. So we pick one and say that if it is not blank, then run the comparison.
Give this a whirl...
=IF([Submitted By]@row <> "", IF([Submitted By]@row = [Hiring Contact Email]@row, "YES"))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Really you only need to check if one is blank. If the other is not blank, then it definitely won't match. So we pick one and say that if it is not blank, then run the comparison.
Give this a whirl...
=IF([Submitted By]@row <> "", IF([Submitted By]@row = [Hiring Contact Email]@row, "YES"))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
As expected, this worked perfectly!!!! Thank you so much!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!