Removing Duplicates

Khari Shiver
Khari Shiver ✭✭✭✭✭
edited 01/30/23 in Formulas and Functions


I have a sheet that I am going to import data into via Data Shuttle that contains a list of requests that need to be approved by a manager. Once the data is imported, I am going to set up an automation that sends an email notifying the manager they have a pending request. The challenge is one manager's email address may appear on the sheet more than once and I only want one email to be sent.

I think I need to find a way to move only one instance of each email address to another sheet and send the alert from the secondary sheet. All that said, I'm not sure how to approach and solve this one. Any advice would be extremely helpful.

Also I currently have two date columns in the system that are generally two days apart if that helps with a solution.

Thank you in advance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!