Reporting RAG against % task complete in Project | MS-Project forum

Resolved · Medium Priority · Version 2003

Thu 25 Jun 2009, 15:28 Delegate 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

Thu 25 Jun 2009, 16:22 Trainer 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

Fri 26 Jun 2009, 09:25 Delegate 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