Can Smartsheet automatically update "Planned" dates based on "Actual" dates?

tariq.shaikh@signspecialists.com

We use "Baseline", "Planned" and "Actual" Start & Finish columns on our projects.

Is there a way to automatically update "Planned" dates for successor activities based on the "Actual" dates for predecessor activities?

e.g. If a predecessor's "Actual Finish" occurs 2 days earlier than its "Planned Finish", can Smartsheet pull "Planned Start" and "Planned Finish" dates for successor activities by 2 days?

Genevieve P.

Hi @tariq.shaikh@signspecialists.com

Currently the Planned start and finish columns that are set when you apply Baseline to your Project Plan cannot be automatically adjusted when you change the Actual start and finish. The Variance column shows the difference from the Planned to the Actual. (See: Keep Your Projects on Track with Baselines)

The Predecessor column should automatically adjust the Actual start and finish dates when a row ends earlier than it should, if you've used dependencies (see: Enable Dependencies and Use Predecessors).

Cheers,

Genevieve