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
