How to catch duplicate data using formulas or premium apps?
Hi, Good day!
I need help in catching this duplicate data with the same Service Type and Last Name but the First Name is different because the first one has middle initial. Can this be caught by sort of using formula or premium apps like datamesh? Anyone have a great mind or idea how to make a new column and formulas then labeled them as "Duplicate"?.
Thanks in advanced!
Tags:
Best Answer
-
Same service type and last name would be...
=IF(COUNTIFS([Service Type]:[Service Type], [Service Type]@row, [Last Name]:[Last Name], [Last Name]@row) > 1, "Duplicate")
Answers
-
Same service type and last name would be...
=IF(COUNTIFS([Service Type]:[Service Type], [Service Type]@row, [Last Name]:[Last Name], [Last Name]@row) > 1, "Duplicate")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!