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.