Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

805 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