Skip to content
ProjectControls.com
Microsoft Project

Create an Indicator column in MS Project which measures the % complete vs % planned of each activity

In the Open Standard
Ruben ContterMember for 12 years 6 months
Created
5
5
0

Hi,

I have developed a project plan (which includes a % complete and a % planned column) and I wish to insert 3 types of indicators to show me how I am advancing with the progress of each activity:


Green: Shows the activity is on target

Yellow: Shows that the activity is between 1%-10% behind schedule

Red: Shows that the activity is greater than 10% behind schedule

 

I know how to insert the indicator but I don't know what formula I can use to calculate if i'm on target or behind schedule. Any ideas?

 

In case you are wondering, the % complete column I inserted comes by default in project, however, the % planned is a text column which I update by clicking on "upadate project" button on the project tab which automatically updated progress % of each activity. I then copy that information onto the % planned column.

 

Thanks

Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    Anoon Iimos ·
    #1

    planned % in MS Project? was

    planned % in MS Project? was it coming from your baseline schedule or your current schedule? and how about planned % considering early or late?

    Report
  2. 0
    Ruben Contter ·
    #2

    yes, % planned of what needs

    yes, % planned of what needs to be completed up to the date I am consulting.

    To give you some context, in order to calculate the % of planned worked in project, what I do is insert a text column (which will be my % planned column). I then press the "update project" button on the project tab which will update the percentages of each activity of my % complete column. It will indicate how much progress I should be reporting for the date I am consulting for each activity. I then copy the results of that column (% complete) and copy it onto my % planned column. This gives me a reference of what % I should be at, in other words, my planned percentage. I then manually update my % complete column with the real % of advancement I am at with each activity. For example, for a given activity, project might report that I should be at 50% based on the date I am consulting, but the reality is that I am 30% which would mean I am behind schedule. Given the aforementioned, I wish to have 3 indicators to report if i'm on target, 1%-10% behind schedule or greater than 10% behind schedule. To do this I believe I would need a formula I can use to calculate if for each activity if I am green, yellow or red.

    I hope this clears the doubt.

    Any ideas?

    Thanks

    Ruben

     

     

     

     

     

     

     

     

     

     

     

     

    Report
  3. 0
    Ian Watkin ·
    #3

    Hi Ruben, have done something

    Hi Ruben, have done something like this before, and used the formula [% Complete]-Val([Text28]) & "%" to subtract planned from actual % where Text28 contains the % Planned, seems to work. You could then easily set another Text field to display graphics by setting values against test for the results.

    Hope this helps you.

    Regards

    Ian

    Report
  4. 0
    Ian Watkin ·
    #4

    Something along the lines

    Something along the lines of:

    IIf([% Complete]-Val([Text28])<=-10,”Red”,IIf([% Complete]-Val([Text28])<=-1,”Amber”,”Green”))

    should do the trick?

    Regards, Ian

    Report
  5. 0
    Ian Watkin ·
    #5

    Something along the lines

    Something along the lines of:

    IIf([% Complete]-Val([Text28])<=-10,”Red”,IIf([% Complete]-Val([Text28])<=-1,”Amber”,”Green”))

    should do the trick?

    Regards, Ian

    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?