Formula

K

Ken

I'm trying to customize a flag field to show a graphical indicator when a
task is due to start within 3 weeks...this is the formula I'm using but it is
showing the indicator on tasks that have already started...any help would be
much appreciated.

IIf([% Complete]=100,"No",IIf([Flag6],"No",IIf((ProjDateAdd([Current
Date],7201)>=[Start]),"Yes","No")))
 
D

Dale Howard [MVP]

Ken --

Try the formula this way and see if this works correctly:
IIf([% Complete]=100,"No",IIf([Flag6],"No",IIf((ProjDateDiff([Current
Click to expand...
Date],[Start])/[Minutes Per Day]<15),"Yes","No")))

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"


Ken said:
I'm trying to customize a flag field to show a graphical indicator when a
task is due to start within 3 weeks...this is the formula I'm using but it is
showing the indicator on tasks that have already started...any help would be
much appreciated.

IIf([% Complete]=100,"No",IIf([Flag6],"No",IIf((ProjDateAdd([Current
Date],7201)>=[Start]),"Yes","No")))
Click to expand...
 
K

Ken

Still showing yes on some tasks that the start date is in the past. Would it
have anything to do with a constraint? Also I've got the Flag6 statement in
there but don't know if it is needed......I have Flag6 configured for late
tasks.....

Dale Howard said:
Ken --

Try the formula this way and see if this works correctly:
IIf([% Complete]=100,"No",IIf([Flag6],"No",IIf((ProjDateDiff([Current
Click to expand...
Date],[Start])/[Minutes Per Day]<15),"Yes","No")))

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"


Ken said:
I'm trying to customize a flag field to show a graphical indicator when a
task is due to start within 3 weeks...this is the formula I'm using but it is
showing the indicator on tasks that have already started...any help would be
much appreciated.

IIf([% Complete]=100,"No",IIf([Flag6],"No",IIf((ProjDateAdd([Current
Date],7201)>=[Start]),"Yes","No")))
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

Ken --

The DateDiff function in your formula will calculate a negative duration
value for any task whose Start date is less than the current date. As a
consequence, any negative value is less than 15 days. Does that help any?




Ken said:
Here is something interesting.......to troubleshoot I've simplified the
formula to the following:

IIf((ProjDateDiff([Current Date],[Start])/480<15),"Yes")

It still shows a task gives a "yes" for a task scheduled to start on 8/18
even though today is 10/20. When I open the task I see a constraint of
ALAP
and a deadline of 8/18. If I remove that deadline the formula gives a
no......any ideas?

Ken said:
Still showing yes on some tasks that the start date is in the past.
Would it
have anything to do with a constraint? Also I've got the Flag6 statement
in
there but don't know if it is needed......I have Flag6 configured for
late
tasks.....

Dale Howard said:
Ken --

Try the formula this way and see if this works correctly:

IIf([% Complete]=100,"No",IIf([Flag6],"No",IIf((ProjDateDiff([Current
Date],[Start])/[Minutes Per Day]<15),"Yes","No")))

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"


I'm trying to customize a flag field to show a graphical indicator
when a
task is due to start within 3 weeks...this is the formula I'm using
but it
is
showing the indicator on tasks that have already started...any help
would
be
much appreciated.

IIf([% Complete]=100,"No",IIf([Flag6],"No",IIf((ProjDateAdd([Current
Date],7201)>=[Start]),"Yes","No")))
Click to expand...
Click to expand...
Click to expand...
 
Top