+ Start a Discussion
@taani.ax1426@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

PintosPintos

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; ", "")