Display Description from Lookup Table

[Gamlyn]

In Project, I created a custom field and made it alookup table. I populated
the table with values and descriptions. That's fine, when I select the item I
want I see the value in the column in the gantt view.

What I need help with is I want the description to automatically populate
another column, so when I pick the vlaue the description will autofill into
the next custom column I create.

Is there a formular for that action?

 

[JulieS]

Hello Gamlyn,

You'll need to enter the descriptions as arguments into another field
but, yes, it can be done.

For example -- two text fields:

Text1 has a value list with the following selection:
Select one (set as default value)
Apple
Baby
Cat
Dog

Text2 has the following formula:
Switch([Text1]="Select One","
",[Text1]="Apple","Pie",[Text1]="Baby","Small
Child",[Text1]="Cat","Wild",[Text1]="Dog","Fido")

Text1 field selection = Text2 field value:

Select One (Blank)
Apple Pie
Baby Small Child
Cat Wild
Dog Fido


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project