MS Project - RAG status formula
Hi,
I would be very grateful for any assistance to create a formula for a RAG column in project. I have created graphical indicators but require a formula to update automatically.
I require a RAG column to provide the following parameters;
1) if milestone/task is complete 100% = Complete
2) if baseline finish date is greater/later than status date and not 100% complete = Green
3) if baseline finish date is earlier than status date and not 100% complete and equal to or more than 6 days overdue = Red
4) if baseline finish date is earlier than status date and not 100% complete and 1-5 or equal to 5 days overdue = Amber
I hope this makes sense and I would be grateful for any help.
Thank you in advance.
|