Flagging duplicates from 2 separate columns

Jack C
Jack C
edited 12/09/19 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!