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

Written by 

Salesforce MVP | Lightning Champion | 17x Salesforce Certified | Application Architect | 7x Trailhead Ranger | Techforce Services | Australia

Leave a Reply

Your email address will not be published. Required fields are marked *

*