If and is not help

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!