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
    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

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!