+ Start a Discussion
sfdc007sfdc007 

formula text is exceeded Char limit error

Hi,

I have a fomula field on a custom object called as "Campaign topic "  which is not firing and throwing the following error


formula text is exceeded  Char limit


Let me know how to fix it or we just create another formula and concatenate in this Campaign topic formula?


Kindly help me pls

Thanks in Advance
MY FORMULA FIELD :


IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Cloud"), "Cloud; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Communications"), "Communications; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Connected Machines"), "Connected Machines; ", NULL)+
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Core Network"), "Core Network; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "CPE"), "CPE; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Data Center Services"), "Data Center Services; ", NULL)+
IF(INCLUDES(Campaign_Name__r.Campaign_Topic__c , "Machine-to-Machine Pro Serv"), "Machine-to-Machine Pro Serv; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Managed Solutions"), "Managed Solutions; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Med Bus Bundle"), "Med Bus Bundle; ", NULL)+
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Mobility Solutions"), "Mobility Solutions; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Net Conferencing Services"), "Net Conferencing Services; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Other"), "Other; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Parent - Multi"), "Parent - Multi; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Partner"), "Partner; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Professional Services"), "Professional Services; ", NULL)+
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Security Solutions"), "Security Solutions; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Strategic Network"), "Strategic Network; ", NULL) +
IF(INCLUDES( Campaign_Name__r.Campaign_Topic__c , "Thought Leadership"), "Thought Leadership; ", NULL)

 
Best Answer chosen by sfdc007
ssssssssssssss
This will happen when the max number of chars in the formula. Please have a look at the below link and try to follow the steps and reduce the length of the formula text.

https://help.salesforce.com/apex/HTViewSolution?urlname=Formula-field-exceeds-maximum-number-of-characters-1327109401516&language=en_US (https://help.salesforce.com/apex/HTViewSolution?urlname=Formula-field-exceeds-maximum-number-of-characters-1327109401516&language=en_US)

All Answers

ssssssssssssss
This will happen when the max number of chars in the formula. Please have a look at the below link and try to follow the steps and reduce the length of the formula text.

https://help.salesforce.com/apex/HTViewSolution?urlname=Formula-field-exceeds-maximum-number-of-characters-1327109401516&language=en_US (https://help.salesforce.com/apex/HTViewSolution?urlname=Formula-field-exceeds-maximum-number-of-characters-1327109401516&language=en_US)
This was selected as the best answer
sfdc007sfdc007
can you pls help me how to do it , i am struck here