- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 12, 2025 07:37 AM - edited Feb 12, 2025 11:32 AM
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 🙏
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 13, 2025 06:27 PM
Hmm, depends on what rescheduling logic you're using? For what you're trying to do you'd need to use 'Fixed' logic with a buffer of 0 days I think:
With 'Flexible' the dates will only change if you make them overlap, in which case they'd reschedule to prevent the overlaps
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 13, 2025 06:27 PM
Hmm, depends on what rescheduling logic you're using? For what you're trying to do you'd need to use 'Fixed' logic with a buffer of 0 days I think:
With 'Flexible' the dates will only change if you make them overlap, in which case they'd reschedule to prevent the overlaps
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 14, 2025 08:52 AM
This is it, thank you!
