Enable sorting projects by earliest incomplete milestone

Currently, we can sort projects in timeline views and lists based on Due Date or Start Date.

I would like to see the same functionality for Milestones, where projects are ordered by their incomplete Milestones.

Here’s an example:

  • Imagine you have two projects, Project A and Project B.
  • Both projects start in January.
  • Project A is due to wrap up in April, while Project B is due in July.

Even though Project B is due 4 months after Project A, if Project B has major milestones happening in February and Project A’s next incomplete milestone isn’t until March, I would prefer to see Project B above Project A in my list or timeline.

This behavior applies to both past due and upcoming incomplete milestones.

The logic simply pulls the date of the earlier incomplete Milestone (past or present) and sorts the projects by that date. In case of a tie, it could then compare the dates of the next incomplete milestone for each project, and so on.

This use case is more suitable for larger organizations with over 100 projects that may all span H1. In such cases, it’s important to see which projects have significant past or upcoming incomplete milestones that are still pending, rather than sorting by start or end date, which might be the same for all projects.

Has anyone else encountered a need for this feature?