Hi All,
I'm migrating from Smartsheet to Airtable for Project Management and one thing that I am struggling with, that we rely heavily on for project management, is date / task dependencies. Setting this up in Smartsheet is easy and intuitive, requiring no formulas.
Desired workflow:
I want to set the Start Date, the Duration and task Dependency so that, if the Duration or Date(s) of a task change, the downstream tasks, as denoted in the Dependency field, will auto-magically update. I have reviewed this video several times and it makes sense and seems easy, but when I configure my fields following the instructions in the video, it does not work as expected.
Set up:
- Table has a Duration, Start Date, End Date and Dependency fields.
- Dependencies are enabled and set up like the following:
The table looks like the following:
Expectation:
In the Table image above, I would expect that, since the 'Get PB' task is dependent on the 'Get Bread' task, Start Date for 'Get PB' will begin on 12/28/2024, but it does not update to reflect this. In the video, the dates all change to reflect beginning as soon as the predecessor ends.
Can anyone tell me what I am doing wrong? I appreciate any feedback - I feel like I am missing a simple and obvious step and I'm spinning trying to figure it out.😩
Thank you 🙏
