Michael_Burnett - profile

Michael_Burnett · Jun 09, 2022

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...

Michael_Burnett · Jun 09, 2022

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.

Michael_Burnett · Jun 09, 2022

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...

Michael_Burnett · Jun 09, 2022

Thank you for the input! This is very helpful. I will try it out and see how it works before attempting to create a script.

Michael_Burnett · Jun 09, 2022

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.

User Statistics

User Activity

Calculate Start Date for task dependencies

Re: Calculate Start Date for task dependencies

Re: Calculate Start Date for task dependencies

Re: Calculate Start Date for task dependencies

Re: Calculate Start Date for task dependencies