I need help writing a formula. I have a multi-select picklist field (hate them) that I basically need to copy values chosen to a field on a related object (need this for tagging a document for use in Nintex DocGen/DocuSign implementation). I know that MSP's have limited functions but I am not sure how to write the formula for this to work correctly. Below is a sample of a formula I tried but am getting an "Error: Compiled formula is too big to execute (5,275 characters). Maximum size is 5,000 characters".
IF(INCLUDES( Contract__r.B2BLanguages__c, "British English"), "British English", NULL)+
IF(INCLUDES( Contract__r.B2BLanguages__c, "English"),"English" , NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "French"),"French", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Italian"),"Italian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "German"),"German", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Spanish"),"Spanish", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Arabic"),"Arabic", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Bengali"),"Bengali", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Bosnian"),"Bosnian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Bulgarian"),"Bulgarian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Burmese"),"Burmese", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Cantonese"),"Cantonese", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Croatian"),"Croatian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Czech"),"Czech", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Danish"),"Danish", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Dutch"),"Dutch", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Farsi"),"Farsi", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Finnish"),"Finnish", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Flemish"),"Flemish", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Gaelic (Irish)"), "Gaelic (Irish)", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Greek"),"Greek", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Gujarati"),"Gujarati", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Haitian Creole"),"Haitian Creole", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Hebrew"),"Hebrew", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Hindi"),"Hindi", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Hungarian"),"Hungarian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Indonesian"),"Indonesian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Japanese"),"Japanese", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Khmer"),"Khmer", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Korean"),"Korean", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Luxembourgish"),"Luxembourgish", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Malay"),"Malay", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Mandarin"),"Mandarin", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Marathi"),"Marathi", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Norwegian"),"Norwegian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Polish"),"Polish", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Portuguese"),"Portuguese", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Punjabi"),"Punjabi", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Romanian"),"Romanian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Russian"),"Russian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Serbian"),"Serbian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Slovak"),"Slovak", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Swahili"),"Swahili", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Swedish"),"Swedish", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Tagalog"),"Tagalog", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Taiwanese"),"Taiwanese", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Thai"),"Thai", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Turkish"),"Turkish", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Ukrainian"),"Ukrainian", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Urdu"),"Urdu", NULL) +
IF(INCLUDES( Contract__r.B2BLanguages__c, "Vietnamese"),"Vietnamese", NULL)
How can I modify this formula to actually work based on the limit of 5k characters?
Any help will be greatly appreciated!
Thanks so much!
Marie
14 Antworten
There's no way around the Compile Size limit in a Formula Field
You'll need to replace the Formula(Text) field with a Text Field and then use either Workflow or Process Builder to update the Text field using a Field Update Action and then use this Formula in the Field Update Action formula
