Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Aug 20, 2022 09:47 AM
Hello wonderful community!
I’m trying to work with a project plan.
I’ve got my projects, tasks and assignees
I’m working on building a table to show each assignee their “to do” list based on the project plan tasks
2 things -
Is there a way to assign tasks to multiple people based on the person’s department?
Second, is there a way to assign a whole project AND all of the tasks in that project to one person with some sort of formula or automation?
I did find this and it is helping but hasn’t fully addressed what I’m looking to do.Assigning Tasks to Multiple People - #2 by JonathanBowen
Thank you!
Aug 21, 2022 11:57 PM
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?