I'm working on a workflow where the time to complete a task within a project is static but the dates we start the project are dynamic. Is there an easy way to program that? Example below...
*Project A starts on 1/1/2022*
Task1 = 3 months to complete so the due date is 4/1/2022. Range = 1/1/2022 - 4/1/2022
Task2 = 3 months to complete with a 1 month lag so the due date is 5/1/2022. Range = 2/1/2022 - 5/1/2022
Task 3 only takes one month but can start until Task 2 is done so the due date becomes 6/1/2022. Range = 5/1/2022 - 6/1/2022
*Project B is exact same but starts on 6/1/2022*
Task1 = months to complete so the due date would be 9/1/2022. Range = 6/1/2022 - 9/1/2022
Task2= Due date is 10/1/2022. Range = 7/1/2022 to 10/1/2022
Task3= 10/1/2022 - 11/1/2022
My goal if possible is to have a reference cell at the top of the page with a "start date" and then all subsequent tasks would have the calendar range update accordingly. I'm unsure if something like this is possible is SmartSheet.