Problem with the RAG Status in Project


S

Santosh Matada

Hello,

I want to show the BRAG status (Basline RAG status) with graphical
indicators in my project plan using the "Baseline Date" column but
having issues as the graphical indicators are not displayed and the
same column (Baseline RAG Status) is showing as "0" for all the tasks.

Please can you assist. I am using the Formulae below -

Switch([% Complete]=100,3,[Finish]<[Current Date],2,[Finish]-[Baseline
Finish]<=1.5,0,[Finish]-[Basline Finish]<=13,1,[Finish]-[Baseline
Finish]>=14,2)

Graphical Indicators set to = 0 is GReen, 1 is Amber, 2 is Red and 3
is Blue.

Thanks.

S
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top