Formula to auto-populate a large sub-set of contact information data?



I create a 'contact list' for each project, with ~20-30 people assigned to the project (column info pasted below). I wanted to create a "Master Contact List" which would have ~300 contacts pre-loaded in it, such that it starts as a blank template (no contacts added), but as you add a contact's name, the remaining columns flow in (their role, phone number, email, etc). Building out ~300 automated workflows would be a considerable level of effort, so I was wondering if anyone knew if there's a formula that would take less time?

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!