I am trying to figure out a formula that grabs a start date when a previous task ends. So in row 2 the Task Dependency is DEC:Project Setup. In row 1 you see the task is DEC: Project Setup with the task due date being 5/13/2022. I want to create a formula that takes this due date and puts it as the Task Start Date in row 2.
Thanks in advance for any help anyone can provide!
Hi Michael, as you’ve discovered, formulas can only pull data from the same row they’re in.
If you’re open to changing up your workflow / base set up a bit, I would recommend you create a linked field in the table to link tasks together like so:
With this method, any changes to the
Due Date value of
Task 1 will automatically show up in the
Start Date field of
You can find the set up here
Alright, I have run into another problem when adding a layer to my formula. In order for me to add a due date the the newly added start date I want to reference a duration field so that the due date is automatically calculated.
My problem now is that I am running into a circular reference which is preventing me from being able to automatically calculate the end date for tasks.
Yup. Circular reference errors are a major difference between spreadsheets and a database system like Airtable.
What you want is difficult to impossible in Airtable without scripting or massive numbers of automation runs.
I was trying to setup tasks with duration that can correctly setup start/end dates automatically for a planning project, but it seems impossible with linked fields (it says that I'm creating a circular reference if my trying to link start date with predecessors dates, while I'm not, but yeah, the systems seems to think so)
I must say that it is very unfortunate that there is not such a built-in support. It makes the Gantt barely practical beyond an hello world Gantt with hardcoded start/end dates, while the "beauty" of Gantt is to actually adapt automatically when adjusting the duration of a task.
Hope that Airtable will get this feature because it is quite nice otherwise to use!