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!
Comments
-
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?
-
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!
-
So you just want to flag on a row by row basis if the Tracking ID SCAN is anywhere in the Tracking ID column?
-
That is correct, any suggestions?
-
-
Works perfectly! Many thanks Paul!
-
Excellent! Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!