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?

 

Be the first to reply!

Reply