New
Find duplicates where duplicate contains
It would be nice to have the ability to be able to say "Show me all duplicate email addresses where at least one of the duplicates has 'x' value."
For example, here is my database:
| Email Address | SFDC Type |
|---|---|
| JonB@gmail.com | Contact |
| JonB@gmail.com | |
| TimmyT@yahoo.com | Lead |
| TimmyT@yahoo.com | Contact |
| GinaG@msn.com | Lead |
| GinaG@msn.com |
My smart list filters would be:
Duplicate Fields: is Email Address
Duplicate Contains: SFDC Type: is empty
The result would spit out the duplicates where at least one of the duplicates has an empty SFDC Type, like so:
| Email Address | SFDC Type |
|---|---|
| JonB@gmail.com | Contact |
| JonB@gmail.com | |
| GinaG@msn.com | Lead |
| GinaG@msn.com |
Our Possible Duplicates system smart list is at 50,000+ people so to be able to narrow some things down would be very helpful. If there's a better way to do this by all means let me know!