Status Graphical Indicators

L

ljsexton

Does anyone know how to assign graphical indicators to the standard task
STATUS field based upon its value? For example if the status is LATE would
like to show the RED Graphical indicator Instead of the word Late.
I know how to create new field and manually set its value when the STATUS
field changes but this is VERY labor Intensive - not worth the effort due to
the STATUS value changing often and the large number of tasks.
Any suggestions would be most appreciated.
Thanks,
Jackie
 
D

Dale Howard [MVP]

Jackie --

You would need to create a custom enterprise Task field that references the
Status field with the following formula:

[Status]

From there, you create graphical indicators in the custom enterprise Task
field based on the value generated by the formula. Do know, however, that
the information in the Status field is stored as numeric data (either a 0,
1, 2, or 3 if memory serves me). You can read the Help file on the Status
field to learn more about it. Hope this helps.
 
Top