Having dates change by being linked to previous dates

James Richardson

Hello all,

Ive looked and cant find this one ( or i didnt type the right thing in search ).

I have several deployemnet dates set.

Im wondering if I can have all dates change if I change one above them,

EXAMPLE:

On 03/14/17 I have a deployment scheduled.

On 03/21/17 I have a deployment scheduled.

On 03/27/17 I have a deployment scheduled.

On 03/28/17 I have a deploymnet scheduled.

If the deployment on the 14th got delayed and pushed back by two days, is it possible that the rest of the deployments are also pushed back by two days.

Basically I want the changes done to one higher date to reflect in all the ones below it.

Is that possible?

Thanks ahead of time!

Find more posts tagged with

Sheets

Solution Center

Update Requests

Cell linking

Comments

J. Craig Williams

James,

You are looking for Predecessors:

https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors

Craig

DaveWala

Can you have the start date change based on an event later in the work flow? The start date of a kitchen remodel is based off of when the cabinets can be delivered. I've already made a chart but without a specific start date for the project. Now I have a cabinet delivery date and want the tile line to change based of this new input.

Dave

J. Craig Williams

Yes, you can build a project wholly or partially 'backwards'.

See the previous link

You can choose from the following dependency types:

Finish-to-Start (FS) - start after the predecessor finishes.
Finish-to-Finish (FF) - finish at the same time the predecessor finishes.
Start-to-Start (SS) - start at the same time the predecessor starts.
Start-to-Finish (SF) - finish before the predecessor starts.

Craig