Project Charter Template in Smartsheet

SOP: Project Charter Deployment in Smartsheet

Document ID: TR-OPS-PM-004
Effective Date: 2023-10-27
Version: 1.0.2
Review Cadence: Semi-Annual (Q2/Q4)

1. Executive Summary & Purpose

This SOP defines the standardized deployment and operationalization of a Project Charter within the Smartsheet ecosystem. The objective is to transition from static documentation to a dynamic, data-linked environment that ensures portfolio alignment, resource visibility, and executive oversight.

2. Scope & Prerequisites

• Scope: Applies to all projects managed under the Template Registry PMO framework.
• Prerequisites:
  • Active Smartsheet Business or Enterprise license.
  • Permissions: Workspace Admin or Editor-level access to the "PMO Governance" folder.
  • Pre-configured "Project Charter Template" (Asset ID: TR-PMO-CHART-V1).
  • Required Metadata: Business Case, Resource Estimates, Risk Register baseline.

3. Roles & Responsibilities (RACI)

4. Step-by-Step Procedure

Phase I: Provisioning

• Locate the "Official Template Library" in the Shared Workspace.
• Select "Project Charter Template" and choose "Save as New".
• Rename file using convention: YYYYMMDD_[ProjectCode]_[ProjectName]_Charter.
• Set specific user permissions on the new sheet; restrict sharing to Project Team only.

Phase II: Data Ingestion

• Populate mandatory fields (Project Name, Sponsor, Start/End Dates).
• Link "Project Intake Form" data to the Charter via Cell Linking or Data Shuttle (if enterprise-mapped).
• Populate the "Resource Estimate" column using the standard hourly rate card.

Phase III: Operationalizing the Workflow

• Activate "Approval Workflow" (Automation tab > Create Workflow).
• Trigger: "When 'Approval Status' changes to 'Ready for Review'".
• Action: Send update/approval request to the designated Project Sponsor email address.
• Set "Alert" notifications for "Start Date" to trigger 48 hours prior to launch.

5. Quality Assurance & Pro-Tips

• Metric Thresholds: All Charters must reach a 100% "Field Completion Score" before the status shifts from Draft to Board Approved.
• Pro-Tip 1: Use "Column Formulas" for all fiscal calculations to prevent manual override errors.
• Pro-Tip 2: Leverage "Summary Fields" for high-level status reporting instead of sheet-level cells; this enables cleaner integration with Smartsheet Dashboards.
• Common Pitfall: Over-complicating the Charter sheet with too many "helper columns." If the sheet exceeds 50 columns, break the data into a secondary "Details" sheet and link them via INDEX/MATCH.

6. Frequently Asked Questions

Q: Should I link the Charter to the Project Plan sheet?
A: Yes. Use Cell Linking to mirror "Go-Live Date" and "Budget Ceiling" into your project schedule. This ensures that any change in the Charter propagates to the schedule automatically.

Q: Why is my automation not sending to the Sponsor?
A: Verify the "Access" level of the Sponsor. Smartsheet automations cannot trigger to users who do not have at least "Viewer" access to the underlying sheet. Ensure the Sponsor is shared to the sheet with permissions restricted to "Viewer."

End of Document. Authorized by: Julian Vance, Chief Architect.