"Next Milestone" filter

[Steve Scott]

Does anyone know of a clever custom filter that will allow me to list next
milestones only ie how do I isolate the next incomplete milestone from all of
the incomplete miletsones without using a date range - is this impossible or
a job for VBA.

 

[John]

Does anyone know of a clever custom filter that will allow me to list next
milestones only ie how do I isolate the next incomplete milestone from all of
the incomplete miletsones without using a date range - is this impossible or
a job for VBA.

Steve,
Short of using VBA (or possibly a complex formula in a custom field),
how about this approach. First sort by date, then filter by incomplete
milestones. The one you want will be at the top of the sorted/filtered
list.

John
Project MVP

 

[Gérard Ducouret]

Steve,

In addition to John's answer, I would suggest a filter which'll use a custom
field such as Date1 where there'll be a simple formula : [Current Date]
Insert the Date1 field in a table, right click the Date1 header: / Customize
fields / Formula : [Current Date]
Then:
Project/ Filter for / More filters / New...
Milestone equals Yes
And % Complete equals 0%
And Start is greater than [Date1]

Gérard Ducouret

 

[Jack Dahlgren]

Definitely a job for VBA. You could use something like my trace macro to
find out if the predecessors are complete and successors are incomplete. It
is a bit tricky because you need to check the dependency chains, but it
wouldn't bee too difficult.

Find the trace macro here:
http://masamiki.com/project/macros.htm

-Jack Dahlgren