Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the information (Task Name) of that task and move it to a specific row which is titled Next Upcoming Milestone. From there I will have a Sight pointed to that row/cell and pull it into a dashboard. I am stumped having the system choosing the lowest value. Anyone have experience doing what I am trying to accomplish?
Thanks.