Flagging duplicates if 2 criteria match

Hi!

I'm trying to build a formula that will identify duplicates from 2 different columns on the same sheet. So the combination of both need to be repeated. The columns are [RCPT] and [1st Test].

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓

    @Voyage1

    Hey there. I'd create a helper column named "Key" to combine the two values together. Add this formula in and convert it to a column formula. =RCPT@row + [1st Test]

    Then create the duplicate check column named "Dup Check". Add this formula in and convert it to a column formula. =COUNTIF(Key:Key, Key@row)

    Then set a conditional Format on this field so if it is greater than 1, highlight it yellow.

    Is that what you were looking for?

    Ryan

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!