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.

Generating start date based on another record's end date

1498 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tommy_Mckoy
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

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.