Formula for overdue tasks and projects

[Naheed]

Hi Everyone,

Is there anyway to use a formula like to calculate a field
for overdue Projects AND Tasks?

IIF([%complete] <100 AND {finish}< now(), Red, Green)

Where Red and Green are used in graphical indicators to
show red and green lights in the view ?

I'm relay confused about this, there are some formulas on
the lnewsgroup and I tried all of them but nothing seems
to work. I would appreciate any help on this. Any formula
that calculates overdue **Projects and Tasks**.

Thanks in advance,

Naheed

 

[Gary L. Chefetz \(MVP\)]

Naheed:

If you're using 2003, use the sample database restore utility to restore the
sample database onto your server. Look at how these formulas and fields were
created in the samples. This ought to get you going.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-