Shorten Constraint_Type Display

C

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
 
J

John

charles14 said:
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
 
G

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.
 
J

John

charles14 said:
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
 

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