Find duplicates based on multiple criteria

Hello everyone,

I need some help with correct formula to find out duplicates. Is there a way to find duplicate records if case number, client's name, from date, and to date are the same? The first and last records are duplicate but how do I set up a correct formula? I currently only have case number and name columns in my formula but not dates.

Thanks,



Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try something like this...

    =IF(COUNTIFS([Case Number]:[Case Number], [Case Number]@row, [Client's Name]:[Client's Name], [Client's Name]@row, [From Date]:[From Date], [From Date]@row, [To Date]:[To Date], [To Date]@row) > 1, 1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!