+ 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')