Formula Not Running the Next Day.

T

Tim

Hi all,
We use Project Pro with Project Server 2002. In my
project, I added a custom field named "Task Status"
(Number1) with a formula to calculate if the task has
been overdue, and with graphical indicators to show the
status as Red or Green. It works fine. The annoyance is
when I open the project the next day, "Task Status" still
shows like it did yesterday (it should not because the
current date has changed and other tasks and their work
are unfinished). If I change something in the %Complete
field, then "Task Status" would show correctly again. It
seems that the formula in the "Task Status" field does
not run when I open the project. Why? please help.

The formula: IIf([% Complete]<100 And [Finish]<Now(),1,0)
Graphical: = 0 then Green; = 1 then Red
Thanks in advance.
 

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
Problem with the RAG Status in Project 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Red, Yellow, Green Status 1
Earned value (BCWP) showing as zero in chart 0
Tracking EV with a formula 3
RAG status - formula required 4
Help? I need help in making formulas work to accomplish... 0

Top