It would be very helpful if I could link tasks as dependencies (which is already possible) and have my dependent task start dates calculate off its predecessor’s end date. Just like in MS Project, all users would need to input would be the predecessor and duration, then the start and end dates would be automatically calculated.
For now, I’m having to use MS Project or Excel to calculate all the start and end dates based on linkage and duration, then copy/paste that information into Airtable for every single task. When a task date changes, it could impact dozens of other tasks’ timelines. Using only Airtable, I would have to manually check every single task (my projects have upwards of 100 tasks) to decide if it is impacted by the change, and then calculate and update the dates for every impacted task.
This is very time consuming so when a client asks “what is the total impact if I’m 4 days late with this task?” I can’t just make the update and see the change. I have to use a separate tool to calculate that change and get back to them with the response. Needing to rely on a separate tool also means I have to maintain all tasks in both tools. When anything changes, I need to record it both in Airtable and in MS Project.