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"))
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"))
-
As expected, this worked perfectly!!!! Thank you so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!