Custom columns will do this. I will assume you donr know how to do these, so the easy steps are:
1. Insert anew column in project, select "number 1" (assuming its not already in use)- doesnt matter which as long as its a number column.
2. right click on the field heading and select "custom fields".
3,. Click on the button that says "formula" and paste the following into the big box at the top
IIf([% Complete]>0,1000,IIf([Start]<[Current Date]-7,3,IIf([Start]<[Current Date],2,IIf([Start]<[Current Date]+7,1,1000))))
4. Go down to "graphical indicators" at the bottom, and fill it in as in the attached piccy.
5. close all windows by clicking OK.
This will give you a visual indicator of a red flag if a task should have started more than 7 days ago, a red dot if it should have started between 7 days ago and now, and an amber indicator if its due to start in the next 7 days. anything else shows as green.
this works by comparing the expected start date to TODAYS date (so that will be the date you open the programme, so if its the 22nd nov when you look at it that will be the date compared to. If there si any progress logged (ie % complete is 1or more %, then the task will be green (progress has been made), if no progress has been logged and it should have started then it will have an indicator.
If this isnt what you needed or you have probs, post back and we see if we can make a better formula for you.
|