+ Start a Discussion
S N 27S N 27 

Byte size(4000 bytes) limit - Formula

Hi All, I have a multi-select picklist that has 52 values in it. The requirement is to populate the selected values to another long text field. The original multi-select field is labeled "AMP". I have created a long text and updating the values using a workflow field update.Following is the formula I have used.

IF(INCLUDES(AMP__c,'Blue Card PPO'), 'Blue Card PPO'+ '; ',NULL)&
IF(INCLUDES(AMP__c,'Blue Choice PPO'), 'Blue Choice PPO'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Blue View Vision Only'),'Blue View Vision Only'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Comprecare'), 'Comprecare'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Direct HMO'), 'Direct HMO'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Direct POS'), 'Direct POS'+ "; ",NULL)

Likewise I have many more in the list. The problem is whenever I try saving this it gives me an error on the Byte size. It should not exceed 4000bytes. I have managed it to cut it down to 4600bytes. Please help me out on this.
Scott Haleo 4Scott Haleo 4

You can follow below link 

Scott Haleo