Hello Community, 

I am trying to show the Current Active Milestone at the Project level for visibility on projects and reports. I was able to create a rule that updates this field based on a filter using State = Active and Executable = True. When there are dependencies used and only one Active/Executable Milestone at any given time on the project, this works flawlessly. 

The issue arises when there are older WBS in play and dependencies are not properly used. In this case, there can be multiple Milestones with Active/Executable state and the rule always updates with the last Milestone not the first, which would be the preferred outcome. 

Question: Short of updating every project to use dependencies at the milestone level as a limitation to this configuration, is there anyway to bypass this issue and roll up the Current Active Milestone wheather there is one that matches or the first milestone when there are multiple matches.

Hope this makes sense. Thanks in advance.