Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Amn12345

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"
)))

Thanks

@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")))

@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
Amn12345

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