Skip to main content
Solved

Date and task dependencies

Country_Pigeon

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 🙏

Best answer by TheTimeSavingCo

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

 

View original
Did this topic help you find an answer to your question?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+18

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

 

Adam, Consultant @ The Time Saving Co
Country_Pigeon
1 person likes this
  • Country_Pigeon
    Country_Pigeon
Country_Pigeon
  • Country_Pigeon
  • Author
  • Participating Frequently
  • 7 replies
  • February 14, 2025
TheTimeSavingCo wrote:

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

 


This is it, thank you!

Reply


Most helpful members this week

Terms & Conditions