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?