Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

Hello,

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!



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions