Hello!
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 crea...
Does anyone have a suggestion on a better way to track tasks with different due dates and dependencies for a project? even if it might be outside of Airtable I am just curious to gather thoughts about this.
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...
The If statement will only let me search in the same row, but I would like to be able to search the whole column for a specific value. if anyone knows a workaround for a WHERE statement that would be ideal.
