Skip to main content

Greetings,

I am using the Gannt app, would like to set up a project table in which the records build upon each other according to dependencies; e.g.:



  • Start date of record 2 is based on end of record 1.

  • End date of record 2 is based on start date + duration.

  • Then start date of record 3 is based on end date of record 2, etc.

    I have succeeded in getting the end date for a single record to calculate based on start date + duration. However, I am stumped in trying to get the start date for the next record to react to end date from a previous record. My thought was to use my dependency column, but using a formula such as “WORKDAY({Name (from Dependency)}, {Duration}” gives me an error “Can’t save field because it causes a circular reference”.


Any ideas for a solution?


Many Thanks!

Tommy

You can read more about circular references on the support website.


One workaround is to create a gap in the circular logic and then find a way to bridge that gap, either manually or with code. I do not recommend automations for this because you can burn through automation runs too quickly.

Reply


Terms & Conditions