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

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?

Find more posts tagged with

Workspaces

Calendar View

Formulas

Community Platform

Conditional Formatting

Project Management

Account and User Management

Comments

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?

Sign in to join the conversation!

Quick Links

Trending discussions

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet