Check a box for duplicate rows, if also duplicate responses in another column


Hoping I can get some tips on a formula I am struggling with. I am trying to mark a check box based on if I have duplicates, based on two columns.

I am trying to identify duplicates between two rows by doing the following; (1) check entire sheet in one column for the same employee ID number (EID), and then for the rows with a duplicate EID check to see if the rows with the same EID also contain the same ID Color (ID Color).

Any suggestions would be helpful.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!