Flagging duplicates from 2 separate columns

Jack C

Greetings -

I'm having an issue trying to flag duplicates from 2 separate columns in the same sheet. I have been able to flag duplicates in a single stand-alone column but trying to using the same formula with the "COUNTIFS" function is leaving the flagged cell blank (as seen in row 2 of the screenshot attached).

Here is the formula I am currently using: =IF(COUNTIFS([Tracking ID]:[Tracking ID], [Tracking ID]3, [Tracking ID SCAN]:[Tracking ID SCAN], [Tracking ID SCAN]3) = 0, 1, 0))

Any thoughts or suggestions? 

Thanks in advance!

Paul Newcome

I'm not sure exactly what you are trying to accomplish. Using your screenshot...

 

Are you trying to flag the row because it has identical values in the Tracking ID and Tracking ID SCAN columns?

 

What exactly is your criteria for a duplicate flag?

Jack C

Hello Paul,

 

I am trying to flag duplicates not only for the same row but any data in the each of the 2 columns (Tracking ID & Tracking ID Scan).

• The "Tracking ID" column is a data dump from our internal platform.
• The "Tracking ID Scan" column is a part # scanned into the Smartsheet using the Smartsheet Mobile App scanner on the first available cell in that column. 

I need to identify if anything scanned into the "Tracking ID Scan" column is not anywhere in the "Tracking ID" column by the "Duplicate Flag" column not being checked.

 

I hope that helps. Please let me know if you have any other questions. Thanks!

Paul Newcome

So you just want to flag on a row by row basis if the Tracking ID SCAN is anywhere in the Tracking ID column?

Jack C

That is correct, any suggestions?

Paul Newcome

Put this in the checkbox column...

 

=CONTAINS([Tracking ID SCAN]@row, [Tracking ID]:[Tracking ID])

Jack C

Works perfectly! Many thanks Paul!

Paul Newcome

Excellent! Happy to help!