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

Options

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

  • Olivia
    Olivia ✭✭
    Options

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

  • Genevieve P.
    Options

    No problem! I'm glad I could help 🙂

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!