Home SALESFORCE Consideration about Salesforce Picklist field using in the Forumula field

Consideration about Salesforce Picklist field using in the Forumula field

if you refer in your fromula creation times as a Picklist field then you get the below error,

Error: Picklist fields are only supported in certain functions

so try to convert from picklist to TEXT and use it.

    Picklist fields can only be used in the following functions:
  • ISPICKVAL—Compares the value of a picklist to a single value.
  • CASE—Compares the value of a picklist to multiple values.
  • TEXT—Converts a picklist value into a text value so that you can work with the value in functions that support text value, such as CONTAINS. (Only available in formula fields, validation rules, and workflow field updates.)
  • The TEXT function always returns picklist values in your organization’s master language, not the language of the current user.
  • Multi-select picklist fields can only be used in the following functions:
    • INCLUDES
    • ISBLANK
    • ISNULL
    • ISCHANGED (Only in assignment rules, validation rules, workflow field updates, and workflow rules in which the evaluation criteria is set to Evaluate the rule when a record is: created, and every time it’s edited)
    • PRIORVALUE (Only in assignment rules, validation rules, workflow field updates, and workflow rules in which the evaluation criteria is set to Evaluate the rule when a record is: created, and every time it’s edited)

    For more info CLICK HERE

You may also like

Leave a Comment