- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2024 07:33 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 26, 2024 07:12 AM
Hi Jack,
I successfully did that with the following automation:
- When a record is updated: Table A, watching column Start
- Find Records: Table A, find based on condition When "Children Column" has any of "Step 1.Record ID"
- Repeat for : each in step 2
- Update Record: Table A, Record ID = Current List Item's Record ID, set Start field = Step 1's Stop field
How does that work?
