#1
|
|||
|
|||
Highlighting task before start date
Good day all Been using Project very superficially for the last two years or so but need to start delving a little deeper Is there a way to get a task to highlight automatically when it gets to a certain date if there has been no action (by using complete % maybe)? The idea would be to use it as a reminder to oneself. If you perhaps missed a start date and did not indicate any progress after a week then it would get highlighted to indicate inaction. Come to think of it, it would be awesome if you could even get it to highlight with yellow a week before start date and then change to red a week after start date if no action has been indicated. Thanks |
#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. |
#3
|
|||
|
|||
Hi Guloluseus
Thanks for the response. I am however not getting it to work. Have gone through it a few times now (most of which is because I didn't read properly ... I blame the early morning) and have done exactly as stated but end up with a new column with 0's in it and no flags. Any ideas of what I could be doing wrong? Thanks again |
#4
|
|||
|
|||
I have uploaded in zip a programme with the column in. If it doesnt show up, insert new column "number 20", and it will show up.
If it works correctly, copy it into your global settings, and then it can be inserted into any programme yu want. If its still giving probs let em knoew- works for me, but may be that you have a setting diffrent somewhere. I have saved as project 07 format, so it should load in whichever version you have. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Showing a Task Start Date Slip | 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 |
Start date of successor task does not change | 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 |