Using SharePoint to Manage Project Changes & Impacts

One of my favorite questions when interviewing potential project management candidates is, “How do you manage change to your baseline plans.” First of all, many candidates fall into the trap of thinking baseline plans is the same thing as the schedule. Others think that change relates to customers adding features and functions to the product. The easiest way to describe change from a project perspective, is change represents anything that is a permanent (vs. timing) deviation from the original plans that define what is going to be delivered (scope), when it will be delivered (schedule), and how much it will cost (budget).

Using collaboration tools, such as SharePoint, to manage change does not replace the diligence required to identify and manage project impacts effectively, but it does streamline the processes associated with documenting, reviewing and approving the change requests. In addition, SharePoint enhances the ability to effectively communicate project changes throughout the project life cycle.

Creating the Change Request Log

I find it easiest to use a Custom list to create the Change Request Log in SharePoint. The following are the fields I add to this list to improve the identification and tracking of change requests based upon the best practices associated with Project Change Management:

  • Id – System assigned unique identifier assigned for the change.
  • Title – Headline associated with the change request (make sure it is descriptive enough to identify the item from the summary view of the change requests).
  • Status – Drop down selection: Not Started, Documented, Reviewed, Approved, or Implemented.
  • Cost Impact – Numeric field for the estimated impact the change request will have on the project budget.
  • Schedule Impact – Numeric field for the estimated impact the change request will have on the project schedule.
  • Scope Impact – Text field utilized to describe the impact the change request will have on the scope of the project.
  • Comments – Text field utilized to describe the current status of the change request.
  • Attachments – The change request should be supported with more details explaining the request and estimated impacts. A completed project impact document is attached to the change request item.

Below is an example of the Change Request form in SharePoint, and the Project Impact Report template.

cr-input form

cr-project impact report

Managing the Approval Process Using Workflow

Creating workflow for this SharePoint list helps automate the approval and tracking process. At the time the item is added to the SharePoint list, an email is sent to the approver (see below for an example of the email).

cr-email

From this email, the approver can Approve, Request a Change, Reassign, or Reject the change request (see an example of the approval pop-up that is displayed within Outlook).

cr-approval popup

Once the approver performs the approval process, the status of the workflow is updated within the SharePoint list (see the Change Request Workflow column of the All Items view below).

cr-all items

I find it is best to keep the workflow straightforward, with no more than 2-3 approval levels. The benefits associated with approval automation can be lost in time spent on manual intervention if the workflow is too complicated.

Cumulative Impact of Change

It is important to understand the cumulative impact of changes on a project with regards to the scope, schedule, and cost/ budget. Throughout the life of a project, there will be changes. The project core team, project sponsor, and steering committee members should be aware of the cumulative impact of changes (comparing current project performance to the original expectations established in the baseline plan).

The project manager is ultimately responsible for project execution against the baseline. The project manager should be able to explain the evolution of that plan from the original baseline to the current baseline, including all approved changes that have been implemented. Project managers often will fall back on the excuse that the project is over budget or late because there were constant changes, but often cannot quickly explain the changes that account for the primary deviations from the original plan. Effective use of the Change Request Log provides a tool to track and reconcile changes to the baseline plan (and provide as a regular project performance metric).

I create another view within the Change Request list to communicate the cumulative impact of change on the project. This new view filters for only approved or implemented requests, provides a total count of approved/implemented requests, and sums the total schedule and cost impacts. Below is an example of the approved requests view of the change requests.

cr-approved view

Summary

SharePoint provides a great vehicle to capture and track change requests in a timely and accurate manner. In addition, adding workflow to the SharePoint list automates the change review and approval processes. The information captured within this list allows the project manager to communicate effectively around the team’s ability to manage change and accurately describe the cumulative impact of this change on the project.

Advertisements

About Steve Hart
Practice Manager responsible for project leadership & delivery services for the Cardinal Solutions Group in the RTP area. I am a PMP with 25 years of project management and technical leadership roles, have developed an extensive practical knowledge that spans a wide variety of industries, and project delivery approaches. As a practicing PMP, I am a member of the North Carolina PMI chapter. I am an avid sports fan, particularly the Miami RedHawks, Cleveland Indians, Cleveland Browns, and most recently the NC State Wolfpack.

One Response to Using SharePoint to Manage Project Changes & Impacts

  1. Pingback: Using SharePoint to Measure the Impact of Change (KPI) « PM-Foundations

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s