Predicting a Date based on what type in as I complete a step

cvera001

The first column are the dates I complete a task. The fourth column are how many days I have to complete the task. I'm trying to predict the completion date as I enter the dates in the first column. The expected completion date will move up or down depending whether or not I finish the task on time or a few days earlier. How do I do this?

 

Andrée Starå

Hi,

Can you explain in more detail or maybe share the sheet or some screenshots?

That would be very helpful and make it much easier to help you in finding a solution.

Best,

Andrée Starå - Workflow Consultant @ Get Done

cvera001

Starting on step 5, I have 90 days to complete the project as seen on the Goal completion date. As I enter dates starting from Step 5, I want the Expected Date to change as I enter them in the Date Column. So if I take less time to complete a task, my expected date will move up appropriately but if I take more time, my expected date will be pushed.

Andrée Starå

Hi again,

I would set the sheet up with dependencies, start and end dates. With dependencies, the completion date would update throughout the sheet when you move the date of any task.

Would that work for you?