Automatic Project Status from Milestones

Feature Request: Automatic Project Status from Milestones

Summary:
Enable project status to be automatically driven by milestone statuses by default, while still allowing users to manually override the project status when needed. This ensures project health more accurately reflects milestone progress without requiring constant manual updates.

Problem Statement:
Currently, project status must be updated manually, even when milestone statuses already reflect the true state of the project. This creates extra administrative work and increases the risk that project status becomes outdated or inconsistent with actual milestone progress. As a result, stakeholders may see inaccurate project health information and spend additional time validating status manually.

Proposed Solution:
Configure project status to automatically roll up from associated milestone statuses unless a user explicitly applies a manual override.
Use milestone status changes to update the overall project status based on predefined status mapping rules.
Allow authorized users to manually override the project status when exceptional circumstances require a different status than the milestone rollup would indicate.
Provide a clear visual indicator showing whether the current project status is system-driven or manually overridden.
Allow users to remove the manual override and return the project to automatic milestone-based status calculation.

Benefits:
Reduces manual effort required to keep project statuses up to date.
Improves consistency between milestone progress and overall project reporting.
Provides more accurate visibility for stakeholders reviewing project health.
Maintains flexibility for teams that need to reflect special circumstances through manual override.
Supports more reliable status reporting across projects and portfolios.