Picklist Values Translated + Used in Formula Field - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Gonzalo Calado-MorillasGonzalo Calado-Morillas 

Picklist Values Translated + Used in Formula Field

Hallo,

If I use the translation workbench to translate custom picklists

e.g. Gender: Male / Female / Unknown

But then I use a formula field to calculate something based on that value

e.g. IF ( ISPICKVALE (Gender___c, "Male"), ...)

Will that automatically work for all languages or will the formula not work since the value will change in every language?

Thanks!

Gonzalo.

Ahilesh RagavanAhilesh Ragavan
Gonzalo,
Unfortunately, Translation Workbench does not work in Formula fields. Picklist values inside formula fields are always returned in the primary language.

Here is an idea to upvote,latest comment from salesforce says they are looking at delivering this idea soon.
Display translated picklist values in a formula field.
https://success.salesforce.com/ideaView?id=08730000000kn4lAAA

Please mark this as Best Answer if this has helped you.