Help

Gannt Chart Slack Adjustments

Topic Labels: Automations Base design Views
131 1
cancel
Showing results for 
Search instead for 
Did you mean: 
jackhlin
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
Eric_L
6 - Interface Innovator
6 - Interface Innovator

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?