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

Olivia

ss 1.PNG

ss 2.PNG

ss v3.PNG

Genevieve P.

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.

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

Olivia

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

Genevieve P.

No problem! I'm glad I could help 🙂