- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 05, 2024 04:46 PM
I am trying to create a project tracker with a task list and start dates and end dates for each task that are calculated automatically based on a dependent (linked) task and its associated dates. My problem is how to create the first row because no matter what formulas I build for the various date columns, I end up with a circular reference error. I'm expect this is possible in Airtable but I haven't figured out how to do it.
I have tried adding a Manual Date column and a Calculated Date Column and then using this function for the start date of each task
IF(
{Previous Task},
{Calculated Start Date},
{Manual Start Date}
)
But it still gives me a circular error reference.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 05, 2024 09:34 PM
Yeah, I take it you're using a lookup to grab the end date from the previous task or something? I usually workaround this by either writing a script or using an automation to place the lookup field value into an actual date field, and then reference that new date field instead
Not terribly elegant and hopefully someone else has a better idea!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 06, 2024 09:52 AM
Thanks. I can try the automation option. Complicated! It would be nice if AirTable would could look at the value in the field instead of the formula. It would avoid the circular reference.
