Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

reporting rag against

Forum home » Delegate support and help forum » Microsoft Project Training and help » Reporting RAG against % task complete in Project

Reporting RAG against % task complete in Project

ResolvedVersion 2003

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

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

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

MS Project tip:

Avoid Accidental Constraints

The initial default table is the Entry table. Enter a task name and duration, but do not enter start or finish dates. Form the plan using links, predecessors. Typing dates introduces constraints. To remove these constraints, double click on a task, and on the Advanced page of Task Information set the constraint back to As Soon As Possible (all other options are there too.)

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.