Can I identify duplicate values by rows not just by column?

Options

I need to ensure that entries to this sheet are not duplicated based on three columns, the name, the activity, and the start date. The examples I've found only review duplicate values within a column.


thank you for your help!

Answers

  • Kelly P.
    Kelly P. ✭✭✭✭✭✭
    Options

    @StephaniePharm

    You could easily combine the 3 columns in a backend column and then look for duplicates in that new column.

    Hope this helps!

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Options

    I typically create a helper column and do a COUNTIFS formula. Anything over a 1 would be a duplicate. You can then set up any conditions you need to do what you want to with the duplicate row.

    =COUNTIFS([Employee Name]:[Employee Name],[Employee Name]@row,[Activity]:[Activity],[Activity]@row,[Start Date]:[Start Date],[Start Date]@row)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!