Hi, i would like to know when there is a duplicate name per row ( going across). this is what i have

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hey @Olivia

    Thanks for posting screen captures, this helps!

    There's a function in Smartsheet called DISTINCT. What you can do is count how many distinct names there are across your row and compare that to the number of cells filled out. If there are more cells filled than distinct cells, you know there's a duplicate name in there somewhere:

    =IF(COUNT(DISTINCT(Debarker@row:Forklift@row)) < COUNT(Debarker@row:Forklift@row), 1, 0)

    You can put that in your "Duplicates" column and then you don't need a helper "New" column at all! Let me know if this works for you.

    Cheers,

    Genevieve

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hey @Olivia

    Thanks for posting screen captures, this helps!

    There's a function in Smartsheet called DISTINCT. What you can do is count how many distinct names there are across your row and compare that to the number of cells filled out. If there are more cells filled than distinct cells, you know there's a duplicate name in there somewhere:

    =IF(COUNT(DISTINCT(Debarker@row:Forklift@row)) < COUNT(Debarker@row:Forklift@row), 1, 0)

    You can put that in your "Duplicates" column and then you don't need a helper "New" column at all! Let me know if this works for you.

    Cheers,

    Genevieve

  • @Genevieve P. Perfect! I'm new to smartsheets and was stuck on this for so long. really appreciate your help! :) Thanks

  • Genevieve P.
    Genevieve P. Employee Admin

    No problem! I'm glad I could help 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!