Database help! Copying new names to another sheet

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

Hello,

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!