Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# Using formulas in MS Project to indicate status of each task

Posted on 2016-08-26
Medium Priority
826 Views
I want to add a Green, Yellow, Red status indicator to tasks in a project plan without having to do this manually.
Essentially for each tasks the rules are as follows:
1)  If the task Completion % = 100, then the task is complete and therefore Green
2)  if the task Completion % <100 and today's date is 1 day from the Finish date, then the task has the potential of being Late and therefore Yellow
3) if the task Completion % <100 and the Finish date is < today's date, the task is late and therefore Red

My Excel skills in writing formulas is not working for me in MS Project :(
0
Question by:jlove88
• 2

LVL 51

Accepted Solution

Jackie Man earned 2000 total points
ID: 41777879
I did a quick search and the finding is as follows:

If you are using MS Project 2010 or later, the field names have changed.  Use the following formula:

IIf([Scheduled Duration]=0,(IIf([% Complete]=100,5, IIf([Scheduled Finish]<Now()+7 And [% Complete]<100 And [% Complete]>=80,3,IIf([Scheduled Finish]<Now()+7 And [% Complete]<80,4,1)))),IIf([% Complete]=100,5, IIf([% Complete]>=100*(Abs(ProjDateDiff([Scheduled Start],Now())/ProjDateDiff([Scheduled Start],[Scheduled Finish]))),2,(IIf([Scheduled Finish]>Now(),IIf([Scheduled Start]>Now(),1,3),4)))))

Source: http://blog.practicingitpm.com/2013/08/25/improved-calculated-status-indicator-ms-project/
0

LVL 51

Expert Comment

ID: 41777881
In short, it is to create a custom field with the value of the formula and display the results in respective color according to the value.
0

LVL 18

Expert Comment

ID: 41781344
You can actually add the indicators built-in MS project, which can also be customized
The process is fully described here:
0

Author Closing Comment

ID: 41783693
Worked like a charm.  Thank you
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You can provide a virtual interface for remote stakeholders in a SWOT analysis through a Google Drawing template. By making real time viewing and collaboration possible, your team can build a stronger product.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
Progress
Starting up a Project
###### Suggested Courses
Course of the Month8 days, 16 hours left to enroll