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

(2437)

Written by 

I am Sakthivel Madesh, a certified Salesforce Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 13x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply