Help

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

311 0
cancel
Showing results for 
Search instead for 
Did you mean: 
sgrass
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

sgrass_0-1702407734702.png

 

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?

 

0 Replies 0