If and is not help

DHR Temp Assignment Team

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!

Paul Newcome

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"))

Paul Newcome

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"))

DHR Temp Assignment Team

As expected, this worked perfectly!!!! Thank you so much!

Paul Newcome

Happy to help. 👍️