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

cvera001 · 08/01/18

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å · 08/02/18

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 · 08/02/18

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å · 08/03/18

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?

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

Comments

Help Article Resources

Categories