Duplicate values

Options
sbentley
sbentley ✭✭
edited 05/24/22 in Smartsheet Basics

Hi,

I need a formula that removes duplicate data. The unique identifier would be email addresses. I read the best way to do this is to add a checkbox column for duplicates but I can't figure out the formula to automatically check the box if the email address already exists in the sheet. Please help!

Answers