Hi, i would like to know when there is a duplicate name per row ( going across). this is what i have
Best 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
-
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
-
@Genevieve P. Perfect! I'm new to smartsheets and was stuck on this for so long. really appreciate your help! :) Thanks
-
No problem! I'm glad I could help 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!