You need to sign in to do that
Don't have an account?
@taani.ax1426
Formula for multipicklist
HI,
I am using this formula field to map the value of picklist from Account to Lead. Formula is saved, however value is not coming. Please help
IF( INCLUDES( Account__r.HAS_Account_Vertical__c , "LV-D"), "LV-D; ","")+
IF( INCLUDES(Account__r.HAS_Account_Vertical__c , "LV-G"), "LV-G; ", "")+
IF( INCLUDES(Account__r.HAS_Account_Vertical__c , "On-Hwy"), "On-Hwy; ", "")+
IF( INCLUDES(Account__r.HAS_Account_Vertical__c , "Off-Hwy"), "Off-Hwy; ", "")
Regards
Hi taani,
I think your missing the ''&'' instead of ''+''' at the end.
IF( INCLUDES( Account__r.HAS_Account_Vertical__c , "LV-D"), "LV-D; ","")+
IF( INCLUDES(Account__r.HAS_Account_Vertical__c , "LV-G"), "LV-G; ", "")+
IF( INCLUDES(Account__r.HAS_Account_Vertical__c , "On-Hwy"), "On-Hwy; ", "")+
IF( INCLUDES(Account__r.HAS_Account_Vertical__c , "Off-Hwy"), "Off-Hwy; ", "")