Identify Duplicate Submissions

DPSFinance

Hello I'm trying to find a way to identify or highlight duplicate submissions for travel documents. We have various fields that are required for travel submissions, but the ones that area always consistent are the employee ID and departure dates.

I've seen some formulas for IF/CountIFs but can't seem to get them to work with this combo. Perhaps its because the departure date is a date format?

Adam Murphy

Try something like =IF(COUNTIFS([EmpID/Non-Employee VCN]:[EmpID/Non-Employee VCN], [EmpID/Non-Employee VCN]@row, [Departure Date]:[Departure Date], [Departure Date]@row) > 1, 1, 0)

Put this in a helper column of type Checkbox, then if it's a duplicate they will be checked/flagged (you can then use conditional formatting to highlight fields or rows). Hope this helps!