How can I reschedule all the tasks dates based on the last task done?

Pluums23

I Have a entire project but the date is fixed base on the lead time of the project. If i have a delay on a task, i need to see the move on the entire project in a new column, is that possible?

In the image I have the columns "Planned start" and "Planned ending", the dates are fixed. Team is filling the colums "Real Start" and "Real ending". I need the to reschedule all the project in a new column if is has a delay.

jmyzk_cloudsmart_jp

Hi @Pluums23

A standard way to handle such needs is to use dependency and baseline.

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

https://help.smartsheet.com/articles/2482093-baselines

If you enable the dependency, if a task is delayed, all tasks with the task as a predecessor get re-scheduled.

Then, you can use the baseline feature to keep a record of the original schedule and see the variance.

In the demo project sheet below, Start and Finish would be your Real Start and Ending, and the Planned Start and Ending would be Baseline Start and Finish. Task 1 was initially planned to take one day but took two days. Then, Task 2 completed the task in one day. Later, Task 4 started late by days. (Please note that the predecessor value will be removed when you change the start date with dependencies.)

https://app.smartsheet.com/b/publish?EQBCT=0af5edab5b4a4039bd93b45262be6b61