Cross referencing for duplicate numbers
We have a Completed Smart sheet of people we have contacted for an ongoing project. Weekly we get a new sheet which sometimes had duplicate names of people we have already contacted. Is there a way to easily search our new sheet for duplicates found from our Completed sheet?
Answers
-
You could add a "helper column" into this new, second sheet to check the Name column in the Completed sheet and see if the same name appears.
Try a cross-sheet formula like this:
=IF(COUNTIF({Name Column Completed sheet}, [Name Column]@row) >=1, "In Completed Sheet", "No Duplicate")
This says, COUNT if the name in this row is present in the Completed sheet's column. If it is (if the COUNT is equal to - or greater than 1), return "In Completed Sheet".
You can adjust what text appears "In these" when there's a count of 1 or more. Let me know if this makes sense or if you still need help!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives