
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 29, 2020 03:16 PM
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
Reply
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 30, 2020 07:57 AM
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.
