You need to sign in to do that
Don't have an account?

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
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
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")))
Thank you very much Anil Its working fine for me now... :)