Skip to content
ProjectControls.com
Microsoft Project

Milestone Warning İndicator

In the Open Standard
Yücel CicekciogluMember for 8 years 6 months
Created
1
2
0

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 

Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    #1

    Hi Yûcel,Go to Project,

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?