Reporting RAG against % task complete in Project

The UK's most regular instructor-led training courses.
Training information: microsoft professional project server training · Project training · Microsoft Project Training
See also · microsoft project training courses · microsoft.project.course · microsoft+project+courses

Resolved · Medium Priority · Version 2003

8 posts

ReplyThu 25 Jun 2009, 15:28Delegate Samantha said...

Samantha has attended:
Project Intro Intermediate course
Project Advanced course

Reporting RAG against % task complete in Project

Hi there

I'm not sure whether this is possible... I think it might be but can you tell me if I can insert a column to show RAG status on how complete a task is?

Thanks

Sam

Version	Date	Location	Places available	Book	Next place rate (£)
Project Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Mon 19 Apr 2010	Southwark	9		£295	£300
2003	Wed 4 Aug 2010	Southwark	10		£295	£300
2003	Tue 30 Nov 2010	Southwark	10		£295	£300

328 posts

ReplyThu 25 Jun 2009, 16:22Trainer Anthony said...

RE: Reporting RAG against % task complete in Project

Hi Samantha, this is certainly possible but a little difficult to answer completely in a post here. However, have a look at the following thread on this forum:

http://forums.techarena.in/microsoft-project/1001679.htm

...which should point you in the right direction!

Hope this helps,

Anthony

8 posts

ReplyFri 26 Jun 2009, 09:25Delegate Samantha said...

RE: Reporting RAG against % task complete in Project

Thanks Anthony. What I'm trying to achieve is much simpler than this I think...

I am going to be manually changing the % complete column and I just want a formula to show the following:
C = 100%
G = 80-99%
A = 50-79%
R = 0-49%

I'm challenged when it comes to formulas so any further assistance would be fantastic.

Thanks

Sam

· A Project Shared Is A Project Bettered
· Defining a Project's Success
· Three Ways to Make Microsoft Projects Courses More Effective
· Microsoft Project Training Courses - Build on Your Existing Skills
· How to Define Tasks for MS Project

Please browse our web site to find out more about
microsoft professional project server training and other Microsoft training courses.