I would like to populate a people column with multiple people based on 3 other people columns.
For instance, I have the following people columns: Lead, Review, Manager. These are all project dependent, so the 3 columns could be any combination of people.
The automation I see right now is:
When person is assigned then assign (replace) someone as assignee.
The assign (replace) must be a specific person, but I would like to assign the Lead, Reviewer, and Manager to one column, like this:
* When Lead is assigned then assign Lead to Project Team
* When Review is assigned then assign Review to Project Team
* When Manger is assigned then assign Manger to Project Team
I would prefer not to do this in additional software or integration, but any help is welcomed.
Thanks!
Kiel