non-working formula.

[Naomi]

I am trying to create a stoplight function in MS Project and PWA, following a
formula someone created successfully elsewhere, but for the life of me I
can't this formula to work. I have created a column in the Enterprise
global template. called OverDue Task in the Task field with a number type.
This column has the following formula: IIf([%Complete]<100 AND Now() >
[Finish], 1, 0). when this formula is applied to the project, the column is
blank.

I've written the formula out piece by piece and when that didn't work,
tried inserting the parts from the dropdowns

Then I created graphical indicators in non-summary rows where:
equals 0.00 red
is greater than 0.00 green


Then, of course, I saved the template, closed project, reopened
project to an existing ongoing project, and inserted that column.
It's totally blank.
Help!
Naomi

 

[Mike Glen]

Hi Naomi,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Gérard Ducouret]

Naomi,

This formula is working fine for me. If you open an existing project file,
you just have to press the [F9] function key to recalculate the project.
NB : I would not criticize your color choice, but I would invert the two
colors you chose ;-)

Gérard Ducouret

 

[Naomi]

Hi Gérard,

when I apply the formula as I wrote it, the stoplights make sense. Are you
sure they should be inverted? It's working as is.

Naomi
--
Naomi

Naomi,

This formula is working fine for me. If you open an existing project file,
you just have to press the [F9] function key to recalculate the project.
NB : I would not criticize your color choice, but I would invert the two
colors you chose ;-)

Gérard Ducouret

I am trying to create a stoplight function in MS Project and PWA, following
a
formula someone created successfully elsewhere, but for the life of me I
can't this formula to work. I have created a column in the Enterprise
global template. called OverDue Task in the Task field with a number type.
This column has the following formula: IIf([%Complete]<100 AND Now() >
[Finish], 1, 0). when this formula is applied to the project, the column
is
blank.

I've written the formula out piece by piece and when that didn't work,
tried inserting the parts from the dropdowns

Then I created graphical indicators in non-summary rows where:
equals 0.00 red
is greater than 0.00 green


Then, of course, I saved the template, closed project, reopened
project to an existing ongoing project, and inserted that column.
It's totally blank.
Help!
Naomi

 

[Naomi]

Yahoo! Thanks Gerard! Simple and sweet.
--
Naomi

Naomi,

This formula is working fine for me. If you open an existing project file,
you just have to press the [F9] function key to recalculate the project.
NB : I would not criticize your color choice, but I would invert the two
colors you chose ;-)

Gérard Ducouret

I am trying to create a stoplight function in MS Project and PWA, following
a
formula someone created successfully elsewhere, but for the life of me I
can't this formula to work. I have created a column in the Enterprise
global template. called OverDue Task in the Task field with a number type.
This column has the following formula: IIf([%Complete]<100 AND Now() >
[Finish], 1, 0). when this formula is applied to the project, the column
is
blank.

I've written the formula out piece by piece and when that didn't work,
tried inserting the parts from the dropdowns

Then I created graphical indicators in non-summary rows where:
equals 0.00 red
is greater than 0.00 green


Then, of course, I saved the template, closed project, reopened
project to an existing ongoing project, and inserted that column.
It's totally blank.
Help!
Naomi