Flagging duplicates from 2 separate columns

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!

Smartsheet Screenshot dup flag.PNG

Find more posts tagged with

Formulas

Services

Support

IT & Operations

Conditional Formatting

Cell linking

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…