![]() |
#2
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Pmacdaddy | Project | 1 | 01-26-2017 10:14 AM |
Set start and end dates of one task based on one other task only | zamshabeer | Project | 1 | 07-07-2016 11:25 AM |
![]() |
raminraiszadeh | Project | 3 | 09-19-2015 01:41 PM |
How to make a task adjust its end date depending on another task? (Newbie) | ravl13 | Project | 3 | 07-27-2014 06:10 PM |
Task with Start date but no Due date? | bplat | Outlook | 0 | 01-12-2012 08:10 AM |