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
Terry_0101Terry_0101 

How to build a Formula for multiple picklist values?

Hi all,

field:  Status
picklist values:  new, open, closed

If status equals either new or open, then add a checkmark to another field

I have so far:
IF(ISPICKVAL(case_status__c, "new" ),"Yes","No")
 
BalajiRanganathanBalajiRanganathan

You have to use Includes function. the link below will help

https://help.salesforce.com/apex/HTViewHelpDoc?id=tips_for_using_picklist_formula_fields.htm&language=en_US
  
IF(OR(INCLUDES(case_status__c,'new'),INCLUDES(case_status__c ,'open')),'Yes','No')

 
Terry_0101Terry_0101
INCLUDES if for Multi Select?  I have a picklist field.  CASE doesn't seem to work.
BalajiRanganathanBalajiRanganathan
Sorry i thought you have multi select picklist. then the following should work

IF(OR(TEXT(case_status__c) = 'New',TEXT(case_status__c) = 'open'),'Yes','No')
 
sudheer Balledasudheer Balleda
Hii everyone can u guide me how to solve this one which function i have to use


Create a State(Multipicklist) Values(KA,TN,HP,JK,GO,GT,AS,WB)field     on Student object. Write a formula to populate Region if State value KA,TN populate “SOUTH”,HP,JK populate “NORTH”,GO,GT populate “WEST” else “EAST”.