Hey all!
Im currently using the Project Management template airtable has provided to track our engineering projects. Id like to remain using this template as it has some functions built in to show progress of each project, and using the predefined fields they display nicely in Gantt view. This is done by linking records from the Tasks table (each record is a task).
The template has a table for Projects, and a secondary table with all the Tasks.
In our case, every engineering project has the exact same set of tasks, so it wouldn't make sense to keep adding redundant tasks over and over to the Tasks table in order to set up the differing deadlines. I would rather create a new table listing all the tasks for one project, and duplicate the said table and rename for other projects.
The problem with this is that in the Projects table, I can only link to records from one other table, hence the connected formula fields can only show progress of one project.
Im not sure how I would be able to merge all the projects and show all of their tasks and individual status's together. From what I understand it's not possible to link to multiple tables from a single field, so I guess this issue is more a question of how to organize my tables.
Essentially, I need a way to show tasks that need to be completed for each project (tasks are the same between projects), and be able to update the status of said tasks, put in deadlines and assignees, and group similar tasks, so I can view and share as a Gantt Chart.
Then I'd like a separate sheet combining all of the active projects so I can overview the % progress of the projects together.
Hope I wasn't too wordy, thank you for taking the time to read.
Regards,
Gabriel