98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » RAG Status Based on Finish Date
RAG Status Based on Finish Date
Resolved · Low Priority · Version 2013
julia has attended:
Project Advanced course
RAG Status Based on Finish Date
custom field formula required to calculat the RAG based on finish date
RE: RAG Status Based on Finish Date
Hi Julia,
I assume you are comfortable with setting up Custom Fields
The formula you need is
IIf([Baseline Finish]-[Finish]>=5,"Green",IIf([Baseline Finish]-[Finish]>=0,"Yellow",IIf([% Complete]>0,"Blue","Red")))
I've used Baseline Finish because I want to RAG it based on the agreed dates (Baselined) vs the current plan in Project.
You could use the [Start] or [Current Date] fields instead.
The next step is to set up "Values to Display"
Graphical Indicators.
Test
Equals
Values
Red Yellow Green Blue
Image
Choose the Coloured circles to match
I hope that helps
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 7 Sep 2016: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Create own ribbon tab - Project 2010a. In Project click on the File tab |