This is a simple formula based on % completeness of activities in the Project Plan. This shows an accurate status / color of tasks within a Target/Program based around percentage. This will be the new fourth option in Application Settings.
Menu: ADMIN -> APPLICATION SETTINGS
Target Version:
- If Actual End Date has been populated, then its status is Closed
- If Forecast End Date is less than Today’s date and there is no Actual End Date, then its status is Delayed
- If Forecast Start Date is less than or equal to Today’s date and Actual Start Date has no value entered, and Forecast End Date is greater than or equal to Today's date, then its status is At Risk
- If (Forecast Start Date is greater than or equal to Today’s date) OR (Forecast Start Date is less than or equal to Today's Date and Actual Start Date has a value and Forecast End Date is greater than or equal to Today's date), then its status is On Schedule
Program Version:
- If the % Complete equals 100%, then its status is Closed
- If the % Complete is less than the % Time Elapsed and the % Time Elapsed is greater than or equal to 100%, then its status is Delayed
- If the % Complete is less than the % Time Elapsed and the % Time Elapsed is greater than or equal to 75% and the % Time Elapsed is less than 100%, then its status is At Risk
- If the % Complete is greater than or equal to the % Time Elapsed or the % Time Elapsed is less than 75%, then its status is On Schedule
Roll-up Rules to Parent Items:
- If any parent item has a Delayed child item, then the parent is also set to the status of Delayed.
- If the majority of children items are of the status of On Schedule or At Risk, then the parent is the same status as the majority status. (Ex: 4 child items are At Risk and 3 child items are On Schedule. Then the parent status is At Risk).
- If the child items are equal counts between On Schedule and At Risk statuses, then the parent status will be At Risk.