function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Chad RitchieChad Ritchie 

Merging Picklist Value into Formula

Hey guys,

What's the syntax to use for a picklist value in order to have that value merge into a formula? So that way I see the value of the field, and not just the field's name. Thanks!!

Best Answer chosen by Chad Ritchie
Rodrigo_RochaRodrigo_Rocha
Take a look here... https://success.salesforce.com/answers?id=9063A000000pElgQAE

Basically, you would need to check for every single value of the multi select picklist... It's a pain...

All Answers

MagulanDuraipandianMagulanDuraipandian
Use TEXT()
Sample code - http://www.infallibletechie.com/2013/10/field-is-picklist-field-picklist-fields.html
Chad RitchieChad Ritchie
Thanks for that, but I'm trying to use it in a formula like below:

your prospect with " + TEXT(Strategy__c) +" solutions

but it is bringing back this errror:  Field Strategy__c is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions.

So yes it works when I just have text(picklist), but in order for the formula to bring it back I need the " + ...... + ", but when I put it in there it errors.
 
Chad RitchieChad Ritchie
Also I should probably add it is a multi select picklist.
Rodrigo_RochaRodrigo_Rocha
Take a look here... https://success.salesforce.com/answers?id=9063A000000pElgQAE

Basically, you would need to check for every single value of the multi select picklist... It's a pain...
This was selected as the best answer