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
jkcjkc 

Simplifying Formula

Hi,
I'm trying to create a formula that gets all values from a multiple picklist but it exceeds the characters limit of 3900 - the formula I created has 4993 characters

Here is how I get the values:

IF(INCLUDES( multiple_picklist__c , "A"), "A", NULL) + ", " +
IF(INCLUDES( multiple_picklist__c , "B"), "B", NULL) + ", " +
IF(INCLUDES( multiple_picklist__c , "C"), "C", NULL) + ", " +
IF(INCLUDES( multiple_picklist__c , "D"), "D", NULL)

Is there a shorter way to do this?

NagaNaga (Salesforce Developers) 
Hi Jkc,


IF(INCLUDES( Multi_Picklist_1__c , "A"), "A", NULL)  + BR() + 
IF(INCLUDES( Multi_Picklist_1__c , "B"), "B", NULL)  + BR() + 
IF(INCLUDES( Multi_Picklist_1__c , "C"), "C", NULL)

I think this is the only way

Best Regards
Naga kiran
William TranWilliam Tran
Post the whole formula and we'll shorten it for you.

thx.
William TranWilliam Tran
Is this resolved?

Thx
jkcjkc
Sorry for not replying sooner. I waited for the client's response and we found a work around so I won't be needing the formula anymore. Appreciate your help. Thank you