Skip to main content

Gannt Chart Slack Adjustments

  • November 21, 2024
  • 1 reply
  • 26 views

Forum|alt.badge.img+1

Hi All! 

For the Gantt Chart view, does anyone know if there's a way to have airtable automatically adjust all dependent task start dates when the predecessor task is moved up (backward in time)?  

I see that airtable automatically pushes out all dependent tasks automatically if a predecessor task is delayed (this is great!) but if a task duration is shortened or end date is moved back, all of the dependent tasks stay exactly where they are. 

Is there a setting or bit of automation I can add to enable automatic date adjustments in both directions?  This seems like a very basic feature for Gantt charts and doesn't quite make sense to have it only for updates in one direction but not the other! 

Jack

This topic has been closed for replies.

1 reply

Eric_L
Forum|alt.badge.img+6
  • Inspiring
  • November 26, 2024

Hi Jack,

I successfully did that with the following automation:

  1. When a record is updated: Table A, watching column Start
  2. Find Records: Table A, find based on condition When "Children Column" has any of "Step 1.Record ID"
  3. Repeat for : each in step 2
    1. Update Record: Table A, Record ID = Current List Item's  Record ID, set Start field = Step 1's Stop field

How does that work?