Auto populate Assigned to based on reference
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
Check out the Formula Handbook template!