Auto populate Assigned to based on reference

rlakin52911
✭✭✭
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?
Tags:
Comments
-
Hi,
you can definitely achieve what you are looking for with a VLOOKUP formula!
What you need is :
- a Master sheet with one column with the role/name and one column with the corresponding "assigned to"
- to modify your template to put a formula in the "assigned to" column.
The formula will use a cross sheet reference. For more info you can look at this page : https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets?_ga=2.133122638.1502807148.1530523732-1065138192.1513871746
I hope this helps!
Best Regards,
Paul.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!