Automated RAG Status Formula

S

Steve Scott

Can someone assist with just one final tweak to my formula. It currently
depends on having a Date in the Baseline Finish field. If a date is not there
(ie "NA") then I want it to return the value of "A" for amber. I have tried
getting the formula to recognise "NA", NA or null but it is not working - can
anyone assist?

Formula is:-

IIf([%
Complete]=100,"C",IIf([Finish]<Date(),"R",IIf([Number1]>5,"R",IIf([Number1]>0,"A","G"))))

and the formula within Number1 is:-

DateDiff("d",[Baseline Finish],[Finish])
 
S

Steve Scott

thanks - this has sorted it!!

JulieS said:
Hi Steve,

See http://www.projectified.com/microsoft_project/index.html the July 25th
posting titled:
Project 101: Testing for NA in a Date field

Hope this helps. Let us know how you get along.
Julie

Steve Scott said:
Can someone assist with just one final tweak to my formula. It currently
depends on having a Date in the Baseline Finish field. If a date is not there
(ie "NA") then I want it to return the value of "A" for amber. I have tried
getting the formula to recognise "NA", NA or null but it is not working - can
anyone assist?

Formula is:-

IIf([%
Complete]=100,"C",IIf([Finish]<Date(),"R",IIf([Number1]>5,"R",IIf([Number1]>0,"A","G"))))

and the formula within Number1 is:-

DateDiff("d",[Baseline Finish],[Finish])
Click to expand...
Click to expand...
 
J

JulieS

You're welcome Scott. Thanks for the feedback.

Julie

Steve Scott said:
thanks - this has sorted it!!

JulieS said:
Hi Steve,

See http://www.projectified.com/microsoft_project/index.html the July 25th
posting titled:
Project 101: Testing for NA in a Date field

Hope this helps. Let us know how you get along.
Julie

Steve Scott said:
Can someone assist with just one final tweak to my formula. It currently
depends on having a Date in the Baseline Finish field. If a date is not there
(ie "NA") then I want it to return the value of "A" for amber. I have tried
getting the formula to recognise "NA", NA or null but it is not working - can
anyone assist?

Formula is:-

IIf([%
Complete]=100,"C",IIf([Finish]<Date(),"R",IIf([Number1]>5,"R",IIf([Number1]>0,"A","G"))))

and the formula within Number1 is:-

DateDiff("d",[Baseline Finish],[Finish])
Click to expand...
Click to expand...
Click to expand...
 

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

Similar Threads

MS Project. Real progress of the project, % complete 1
RAG formula 1
Automated RAG Status Formula 0
Problem with the RAG Status in Project 0
OT RAG formula 2
RAG status - formula required 4
Formula producing odd behaviour 1
Manual Override a formula 4

Top