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

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?

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.