Update assignments in template based on sheet
How can I assign ownership to tasks based on contacts in a sheet? For example - I have a list of contacts that define the owner of each area for every project. As I am creating a new project from a template, I would like to lookup the owners for the tasks based on the information in the sheet.
Example - project below would be updated based on the master resource sheet.