Help with a formula MSPS2007

[Eric_H]

Ok, guru's... I have a field that is associated with a lookup table that
allows multiple selections, the value of the fields are site codes used by my
organizations and are designed to not change but the name of the sites tend
to change from time to time. So what I have done is use the site code for
the value and the site name in the description (seems logical to me)... It
has been asked that I show the description (site name) and not the code to my
customer... I was thinking a formula might be the answer (I also need to
collect this data and get past the limitations of a multi select field in the
SQL)... My original thought is to create a text field, import the data from
the multi select field, and somehow convert the codes to the names, I need
help with a single formula to bring in the data and then do the convert...
Any Ideas?

 

[Andrew Lavinsky]

You could use a custom formula if you like, probably a switch function. I
might point out that you don't have to make it so complicated. The Lookup
Table values are mapped to the project using a unique ID on the back end.

For instance, if I have

Colors
- Red
- Blue
- Yellow

And I change Blue to Fushcia...then all tasks that were Blue will become
Fuschia the next time the project is opened and published.

That might actually solve your problem with no need to use codes.

 

[Eric_H]

That's a great suggestion, however I have 2 organizations that use the
enterprise field and each is choosing to represent the data differently to
their respective customer, changing the value of the field would solve one
issue, but create another. so for one of the organizations, I wanted to
create the effect of using the same values but represent a different "short
name" or the description as an alternative display for the same info...
Thanks for the idea, I need info on using the switch function.

Eric