#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Project Status and Overdue tasks | stanleysamuel | Project | 1 | 10-12-2016 11:32 AM |
Project Late Status Changes from One User to Another | cookieburk | Project | 4 | 06-01-2016 12:31 PM |
Project Status and Late Tasks - Incorrect | BarryB | Project | 4 | 08-02-2015 01:50 PM |
RAG Status on Project 2013 | deepsk | Project | 3 | 04-23-2015 07:26 AM |
MS Project Start Dates not matching the Status Date | sjodom | Project | 3 | 12-04-2011 08:45 AM |