Graphical indicator field to reflect constraint type

[wendyB]

I have created a custom field with graphical indicators but cannot seem to
get the syntax for the formula right. I would like get the graphical
indicator column to change based on the constraint type for each task.

e.g.

if, constraint type = as soon as possible, then graphical indicator = green
if, finish no later than, then graphical indicator = blue
.... etc.

I have tried using a value list but would rather have the value pointing to
the constraint type already set for each task.

Alternatively, is there a way to truncate the value in the constraint type
rather have the full text displayed in the constraint type column, maybe a
text column to show "FNLT" if constraint type = Finish No Later Than, as so
on.

Thank you.

 

[Joaquim Amado Lopes]

Hello, Wendy.

The Constraint Type is a numeric field.
0 = As soon as possible
1 = As late as possible
2 = Must start on
3 = Must finish on
4 = Start no earlier than
5 = Start no later than
6 = Finish no earlier than
7 = Finish no later than

Use one of the custom number fields (Number1, Number2, ...), setting
it to be equal to the field Constraint Type (the formula is just that:
[Constraint Type]) and to use the graphical indicators.

Using the examples in your post,
0 = indicator green
7 = indicator blue
...

Hope this helps.
Cheers,
Joaquim Amado Lopes

 

[Gérard Ducouret]

Hello Wendy,
Insert a Text field such as Text1
Tools / Customize / Field
Rename it as you want
Formula : [Constraint Type]
Graphicals Indicators :
Test for : Equals , Value : 2, Image : Red symbol
....etc
NB : Value 2 = Must Start On

Gérard Ducouret