+ Start a Discussion

Formula Field From Picklist Field Type

I want a formula field on opportunity that defaults to the value of a field on the Account. Usually it would be easy to set the formala to Account.FieldName.

Problem is it errors because Account.FieldName is a picklist field type. How would I set the forumula so this will work?
You would need to use ISPICKVAL or CASE functions in order to reference a picklist in a formula. While creating the formula, you can select the function and click on the "Help on this function" link to get more details on the syntax and how to use these functions in the formula