Shorten Constraint_Type Display

[charles14]

Since there are only half a dozen possible entries for this field is there a
way to shorten it up so it does not require 21 spaces of my screen to show
SNET,ASAP,ALAP,FNLT etc. We are scheduling to the hour so dates are eating up
a lot of my screen space. Please help, Charles

 

[John]

Since there are only half a dozen possible entries for this field is there a
way to shorten it up so it does not require 21 spaces of my screen to show
SNET,ASAP,ALAP,FNLT etc. We are scheduling to the hour so dates are eating up
a lot of my screen space. Please help, Charles

Charles14,
I assume you are talking about the Constraint Type field. The easiest
fix is to not display that field. However, if you do wish to see the
constraint type, designate a spare field and then customize it with a
formula that converts the value to an abbreviation. Since the Constraint
Type field actually contains integer values corresponding to the various
constraint types, the following formula will single out the
as-soon-as-possible constraint.
IIf([Constraint Type]=0,"ASAP","other")

Expand that formula construct to include all the constraint types, or at
least those you are using.

Hope this helps.
John
Project MVP

 

[charles14]

Worked like a champ, thank you so much. Just what I needed.

 

[Gary L. Chefetz [MVP]]

Charles:

When you set a constraint on a task, an icon displays in the indicators
column. To quickly find out what type of constraint is set on a task, hover
your mouse pointer over the icon.

 

[John]

Worked like a champ, thank you so much. Just what I needed.

Charles14,
Hey, champ is what we do. You're welcome and thanks for the feedback.

John

Charles14,
I assume you are talking about the Constraint Type field. The easiest
fix is to not display that field. However, if you do wish to see the
constraint type, designate a spare field and then customize it with a
formula that converts the value to an abbreviation. Since the Constraint
Type field actually contains integer values corresponding to the various
constraint types, the following formula will single out the
as-soon-as-possible constraint.
IIf([Constraint Type]=0,"ASAP","other")

Expand that formula construct to include all the constraint types, or at
least those you are using.

Hope this helps.
John
Project MVP