Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Date and task dependencies

Topic Labels: Automations Base design
Solved
Jump to Solution
226 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Country_Pigeon
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Screenshot 2025-02-12 at 10.26.12 AM.png

The table looks like the following:

Screenshot 2025-02-12 at 10.26.31 AM.png

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 🙏

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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:

Screenshot 2025-02-14 at 10.25.31 AM.png

Screen Recording 2025-02-14 at 10.26.30 AM.gif

With 'Flexible' the dates will only change if you make them overlap, in which case they'd reschedule to prevent the overlaps

 

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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:

Screenshot 2025-02-14 at 10.25.31 AM.png

Screen Recording 2025-02-14 at 10.26.30 AM.gif

With 'Flexible' the dates will only change if you make them overlap, in which case they'd reschedule to prevent the overlaps

 

This is it, thank you!