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 (£)		List price
Project Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Tue 14 + Wed 15 Sep 2010	Bloomsbury	6		£485	£490	£495
2003	Mon 27 + Tue 28 Sep 2010	Bloomsbury	4		£495	£495	£495
2007	Mon 27 + Tue 28 Sep 2010	Southwark	7		£485	£490	£495
2007	Mon 11 + Tue 12 Oct 2010	Bloomsbury	8		£450	£455	£495
2007	Thu 21 + Fri 22 Oct 2010	Limehouse (Docklands)	7		£485	£490	£495
2010	Thu 21 + Fri 22 Oct 2010	Bloomsbury	6		£525	£530	£595
Full Schedule: See all 54 Project Intro Intermediate course dates. Bookings currently available until 26th September 2011.

504 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

· Basic Project Management Skills
· Better Project Management: Using the Project Management Triangle
· How To Customise The Gantt Chart View In Microsoft Project 2003 And 2007
· Smart Tips for Preparing a Budget in MS Project
· Getting Your Project Started With Project

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

Ms project tip:

Format individual bars on your GANTT chart

To draw attention to a bar on your Gantt chart simply double click it. From the dialogue box that opens make your selection of text and bar modifications.

View all MS Project hints and tips