Project Management Office

1

Create a New Workspace

2

The Project Intake Sheet Form

3

Copy the Project Template Folder

4

Copy the Project ID

5

Cell Link from the Project Intake Sheet

6

Site / Project Categories

7

The Project Intake Form

8

New Project Approval Request

9

Project Portfolio Rollup Dashboard

10

Modify the Project Plan Sheet

11

Sheet Bonus: Use Baselines to track project status

12

Adjust Durations & Predecessors

13

Assign Tasks to Team Members

14

Adjust Alert

15

Sheet Summary: View or Edit Your Project Summary Data

16

Update Status and Filters

17

Use the Overdue Report

18

Schedule Health Column

19

Monitor the Individual Project with the Site Plan Tracking and Rollup Dashboard

20

Delete the Sample Data from the Project Intake Sheet

21

Share Your New Solution

18

Schedule Health Column

The Schedule Health column on the Project Plan leverages a number of columns and formulas.
Hover over each step to view a walk-through
A
End Date - The Actual End Date of the task.
B
Target End Date - Set at the beginning of the project as the planned End Date of the task.
C
Duration - The number of working days between the Start Date and End Date.
D
Schedule Delta (Working Days) - Number of days +/- between the End Date and the Target End Date.
E
Schedule Delta % - The percentage of days +/- to the schedule.
=IFERROR([Schedule Delta (Working Days)]@row / Duration@row, "")
F
The Schedule Health column uses the following formula logic rules:=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")If Schedule Delta % is greater than 10%, then RedIf Schedule Delta % is greater than 0 but less than 10%, then Yellow - These are tasks to watch as they could push the project to an unacceptable timeline.If Schedule Delta % is less than or equal to 0, then Green - These are tasks that are on schedule or faster
Learn More:
Dropdown List
Filters
Shared Filter
Project Plan