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
Amn12345Amn12345 

AND loop for field type Multiselect picklist is not working.. Pls Help..

I have a formula which depends on what value is selected,

Options are Take-Out, Acquisition, Both, None.. In formula AND loop for "Both" is not working. My formula is executing fine.

 

IF( 
INCLUDES(Investment_Use__c, "Take-Out"), "Take-Out", 
IF(INCLUDES(Investment_Use__c, "Acquisition" ), "Acquisition", IF( 
AND( 
INCLUDES(Investment_Use__c, "Acquisition" ),
INCLUDES(Investment_Use__c, "Take-Out" ) 
), 
"Both", "None" 
)))

 

What could be the problem?? Please need your help

 

Thanks

Best Answer chosen by Admin (Salesforce Developers) 
@anilbathula@@anilbathula@

HI

 

I think Investment_Use__c is a multi selct picklist.

if its a multi select then try this formula.

IF(
AND(
INCLUDES(Investment_Use__c , "Take-out"),
INCLUDES(Investment_Use__c , "Acquisition")
), "Both",IF(INCLUDES(Investment_Use__c,"Take-out"),"Take-out",IF(INCLUDES(Investment_Use__c,"Acquisition"),"Acquisition","None")))

 

 

 

All Answers

@anilbathula@@anilbathula@

HI

 

I think Investment_Use__c is a multi selct picklist.

if its a multi select then try this formula.

IF(
AND(
INCLUDES(Investment_Use__c , "Take-out"),
INCLUDES(Investment_Use__c , "Acquisition")
), "Both",IF(INCLUDES(Investment_Use__c,"Take-out"),"Take-out",IF(INCLUDES(Investment_Use__c,"Acquisition"),"Acquisition","None")))

 

 

 

This was selected as the best answer
Amn12345Amn12345

Thank you very much Anil Its working fine for me now... :)