Milestone Warning İndicator

Member for

22 years 9 months

Hi Yûcel,

Go to Project, Custom Fields, then create a task flag field with the following formula:

"IIf([Duration]=0 And [% Complete]=0;IIf(ProjDateAdd([Finish];19200;"Standard");"Yes";"No");"Not a milestone")"

where 19200 is the number of minutes of a 2 mont period according MS Project "Standard" calendar where 1 day equals 8 hrs and 1 month equals 20 days, thus 8 x 60 x 20 = 19200; and "Standard" is MSP default calendar

you will have to change these two infos when necessary

then go to "Values to display" at the bottom of the dialog box, click Graphicla Indicators, and insert 2 rows for "yes" and "no"; at the  top of this dialog, select "Nonsummary rows"

I hope this helps you

Alexandre