Automated RAG Status Formula

S

Steve Scott

I currently have the following formula:-

IIf([Milestone]=-1,IIf([% Complete]=100,"Complete",IIf([Baseline
Finish]=ProjDateValue("NA"),"No baseline Set!",IIf([Finish]<Date
(),"Reforecast",IIf([Number1]>5,"R",IIf([Number1]>0,"A","G"))))),"NM")

Can I extend it further to perform the following checks as well:- (ie how
big can my formula be!!)


1) Amend the formula sp that it only works on tasks flagged as milestones.

2) Using another text field to act as reporting level (say for reporting
levels 1,2,3,4 and 5) and then apply the above RAG formula but with differing
"slippage days" depending upon what Level is in the text field.


Thanks in advance

Steve
 

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

Enhance formula 2
RAG formula 1
Formula producing odd behaviour 1
Manual Override a formula 4
Automated RAG Status Formula 3
RAG status - formula required 4
Tracking , Resource Loading & % Complete querry 0
Formula for stoplight 3

Top