Custom Ent Fields - Functions

R

RickD

I've defined a project status field with an associated pick list. In my view however, I want to replace the single numeric value with the descriptive field. What function is best for doing this?

Examples: 1=Pre-approval; 2=Approved; 3=Complet
 
D

Dale Howard [MVP]

RickD --

An approach that I would use would be to create a custom Text field that
would be used in the View instead of the custom status field. The custom
Text field would reference the custom status field and would use an IIF
formula or a SWITCH formula to select the appropriate text. Just a thought.
Hope this helps.




RickD said:
I've defined a project status field with an associated pick list. In my
Click to expand...
view however, I want to replace the single numeric value with the
descriptive field. What function is best for doing this??
 
Top