Red light, yellow light, green light

[anovak]

Could someone share an appopriate formula to be used for the creation
of a color-coded status button that would work on-going based on
current date, etc?

Thanks,
Andy Novak
University of North Texas

 

[Mauricio@BVFG]

Andy,

Here you have my two cents:

On a custom text field use the following formula:

IIf(DateValue([Finish])-DateValue([Start])=0,"0",IIf([%
Complete]=100,"1",IIf([Finish]<now(),"2","3")))

On the Graphical Indicators for the same custom field set the following
conditions:
1) Test: equals, Value: 0, (Select the image you want to display for this
case)
2) Test: equals, Value: 1, (Select the image you want to display for this
case)
3) Test: equals, Value: 2, (Select the image you want to display for this
case)
4) Test: equals, Value: 3, (Select the image you want to display for this
case)

Be shure you display the column in the view you are using.

This is a formula I am using for a specific condition I am tracking. You
will need to modify it to match your own reality. I hope this to be useful.

Mauricio

 

[anovak]

I created an enterprise text field at the task level (Enterprise Task
Text2). Two problems:

1. After I save Enterprise Global and go into the views mgt piece of
the PWA to add the field to a particular view (Copy of Task Summary),
the system-level column label appears (Enterprise Task Text2) instead
of "Schedule" (which I renamed the field in Enterprise Global). I
added to project level enterprise fields called "Performer" and
"Product" and they display just fine within the modified PWA view.
What's the deal???

2. Your formula was pasted "as is" before saving the new enterprise
task text field (and Enterprise Gobal). When I view the field in the
view within a project, all lines are blank. Shouldn't there be some
values showing there? Some tasks are complete, some are partially
complete, etc. I would think I wouldn't have all spaces.

Please advise. Thanks, Andy