cranky formula for stoplights?

N

Naomi Nissen

I've tried to duplicate a formula from posting
http://groups.google.com/group/micr...a?lnk=gst&q=stoplight&rnum=9#e1258d742e236b6a
that for the life of me I can't get to show any results in the
inserted column.

I created a custom field in Enterprise global called OverDue Task:
Task field with a number type.

I've written the formula out piece by piece and when that didn't work,
tried inserting the parts from the dropdowns, as such:
IIf([% Complete]<100 And Now()>[Finish],1,0)

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
 

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

Top