Is there a way to select from a project schedule the next upcoming milestone?

Phil,

If you are going to use a Sight, that actually makes it easier.

1. Somewhere, you need this formula:

=MIN([Days to MS]:[Days to MS])

where the column name is Days to MS.

It needs to be somewhere besides the Days to MS column or you will get a circular reference.

This will tell you the shortest days to the MS..

It won't tell you if there are more  than one, but that is taken care of below.

2. Create a new column.

I called mine VL MS

In that column either of these will work:

For a check box:

=IF([Days to MS]14 = Info$1, 1, 0)

or

For a text/number:

=IF([Days to MS]13 = Info$1, [Task Name]13, "")

where Info$1 is where the first formula was located.

I have a column called Info where I store these odd one-off calculations.

3. Create a Report

Have the report show the Task Name column based on whether the new column has either (depending on which you used) a 1 (check box) or is not blank (text/number)

4. Put the results of the Report into the Sight.

And that should do it.

Craig

Great!

Craig