Hello
I am trying to write a formula that will show a RAG status (Red/Amber/Green and Complete) in a custom field in MS Project, based on the following criteria:
1. If the task is complete then it shows a tick graphical indicator. and if the task has completed ahead of time (based on the finish date) then it shows a green happy smiling face graphical indicator.
2. If the task is incomplete and todays date has passed/ the task finish date is less than todays date (i.e. the task has slipped) then it shows a Red graphical indicator. and If the task has slipped by more than 3 weeks it shows an unhappy red face.
3. If the task is incomplete (and less than 75% completed) and there are 7 days or less left until the finish date then it shows a Amber graphical indicator.(i.e. warning task may slip)
4. If the task is incomplete and there are more than 7 days left until the finish date then it shows a green graphical indicator. (i.e. task is on track)
I would then select the graphical indicators whereby:
complete is C
red is R
amber is A
green is G
Im not at all technical so have started writing a formula, but its very basic as i dont know how to write a formula to do the above:-
IIf([% Complete]=100,"C",IIf([% Complete]<100 And [Finish]<[Current Date],"R",IIf([% Complete]<100 And [Finish]>[Current Date],"G")))
Please could you help??
many thanks
Bookmarks