Skip to main content

Calculating start and end date of tasks for a gantt chart (circular reference error)

  • December 12, 2023
  • 1 reply
  • 52 views
sgrass
Forum|alt.badge.img+6

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?

 

      This topic has been closed for replies.

      1 reply

      Steven_Lehrburg
      Forum|alt.badge.img+6

      ​@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 & ConditionsAccessibility statement