Dear All;
i have a question about milestone that i want to see if its should be done in 2 months could be warned by ms project?
for example: i have a summary task that building reinforced concrete works, and i linked this after a "rebar procurement" milestone. the thing that i want to do is, can i make ms project put a flag or warning before 2 months left to this milestone, so i can warn my manager about "we should supply rebar in 2 months".
Thanks
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