- Make it possible for an automation to assign someone to a certain “people”-column based on whoever is in a different “people”-column.
So basically dynamically duplicate a person from one people-column to another people-column, without having to make an automation for every person you want to apply this to;
We have many boards with different workflows that work as follows: When a status changes from one task to another it automatically clears the assigned person and assigns a next person depending on the task. Some tasks are assigned to a person in a seperate representive-column (see above) other tasks to a whole team. The automations to do this are set up like this:
Automation 1 per task:
When Status changes to “Done”: set Status to “Task 2”. and Unassign People-column.
Automation 2 per task and per person:
When Status changes to “Task 2” and only if Name Status is “Person X”: Assign “Person X” as People-column.
The problem with this is that for each task I have to repeat the second automation for all the names in the custom made “Name Status”-column that one task applies to. And if a name is added/removed I also have to manually update the “Name Status”-columns and all the automations. A lot of work.