Database help! Copying new names to another sheet

lisa.bolger27646 ✭✭✭✭
edited 01/26/23 in Formulas and Functions


We have an intake sheet to manage requests for employees to work on projects. This intake sheet wmay have an employee listed for one or multiple projects and we would like to keep use this intake sheet to source a database where there should just be one row per employee.

Is there a formula to help copy just the new employees so there are no duplicates in the database?

Happy to provide any other details.

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!