Formula producing odd behaviour

S

Steve Scott

I am testing a RAG status formula which works ok but when I add a task it
erases previous values on tasks above it that it had calcualted prior to the
new task being added. Any ideas?

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

JulieS

Hi Steve,

Just a quick thought ....When you are adding the new task, is it a subtask
of the task above it? Do you have the summary tasks using the formula?

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

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
Custom Fields/Formulas Receiving an error "NA" in Project Center 0
Enhance formula 2
Automated RAG Status Formula 0
Manual Override a formula 4
Tracking EV with a formula 3
Tracking , Resource Loading & % Complete querry 0

Top