Skip to main content

Hi all,

I'm trying to create a gantt where I could provide a start date for the first task and from there the start dates and end dates of all other tasks would be calculated automatically (the start date of a task is the MAX of the end dates of all its predecessors).

I have a the predecessors as self Links to the same table. I have their max as a Rollup.

I have the end date being the Start Date + Duration, using this formula:

DATEADD({Start date},Duration/60,'minutes')

and I have another field called "Actual Start Date" in which I intend to provide the start date of the first task manually.

When I try to add the formula for the Start Date I hit the circular reference error:

 

I saw this post from 2018 describing the same need, but was hoping that since then it became possible.

Anyone knows if this can be done?

 

​@sgrass I’m not sure when they added this, and I realize you may have moved on, but there’s now built-in support for this using something they call “Date Dependencies”. Details here: https://support.airtable.com/docs/date-dependencies-in-airtable

Terms & Conditions