Looking for a formula

=IF(AND([Email: I do not want vaccine]@row <> "", COUNTIFS([Email: I do not want vaccine]:[Email: I do not want vaccine], [Email: I do not want vaccine]@row) > 1), "Duplicate")

The email is not always mandatory which is why I need to be able to leave blank cells alone and if there is a true duplicate I need to be able to see the original (or one of) the submissions to be able to not only count number of submissions but as well as use automation to move duplicates to an archive sheet and not count as a true number for dashboard calculations.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!