Duplicate check in two columns using IF OR and COUNTIF

I need to check two cells to see if they already exist on the sheet so I'm using a duplicate check formula and OR, but it's not working properly. It works for the email address, but the Full Name does not work.

=IF(OR(COUNTIF([Full Name]:[Full Name], [Full Name]@row) > 1, 1),COUNTIF([Email Address]:[Email Address], [Email Address]@row) > 1, 1)

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓



    =IF(COUNTIF([Full Name]:[Full Name], [Full Name]@row) > 1, 1, IF(COUNTIF([Email Address]:[Email Address], [Email Address]@row) > 1, 1,0))



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!