MS Project Tasks Due

J

jonathon.levin

I am having issues writing a custom equation in MS Project that can
put an indicator next to any task that is due from the current date to
+14 days forward. Does anyone have any experience with this?

Thanks In Advance,
Jonathon
 
J

Jack Dahlgren

Answered in the other newsgroup. Please do not post the same question to
multiple newsgroups. It becomes more difficult for people to respond and for
you to find an answer.

-Jack Dahlgren
http://zo-d.com/blog
 
J

Jim Erwin

Sample to start from (local within a project plan - not enterprise):

IIf([% Work Complete]=100,"Completed",(IIf([Finish]<=([Current Date]
+1),"Red",(IIf([Finish]>([Current Date]+1) And [Finish]<=([Current
Date]+7),"Yellow",(IIf([Finish]>([Current Date]+7) And
[Finish]<=([Current Date]+14),"Green","Blue")))))))

I setup graphical indicators with obvious associations, too.
Hope this helps!
 
Top