Hmm, I’m assuming that each assignee is a single record inside an
Employees table or some such that includes the department information? If so, and you’re doing this via an automation that triggers per task, you could do a
Find Record action based on the department, and then update the task’s assignee linked field with the list of record IDs it found in the
Find Record step.
Similar to the above, we would do a
Find Record action for all tasks that are within a project, and update that person’s record’s task linked field with the list of record IDs that were found
If my assumption about your base setup was wrong, could you provide some screenshots of your tables so that I could help further?