Auto populate Assigned to based on reference

rlakin52911 ✭✭✭
edited 12/09/19 in Formulas and Functions

We have a project plan template and populate the 'assigned to' column with the role/title.

Once I copy the new project plan template, how could I automatically update the 'assigned to' by task based on a role/name mapping.

Could I have a project resources sheet with role and name and have the Project Plan tasks 'assigned to' fields auto populate with the role - name mapping?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!