You need to sign in to do that
Don't have an account?
Shiva Venu
concatenate 5 different picklist fields values
I want to concatenate 5 picklist fields values on the Lead object. All are single pick fields. I am creating a formula field to do so (let me know if there is any other best approach, but wanted to achieve through configuration not code).
Output format : Picklist1_Picklist2_Picklist3_Picklist4_Picklist5
condition :
1. underscore should skip if any value is null or blank.
2. For picklist 1 it should only add selected values (Eg : Pickvalues : a, b, c, d, e, f : it should only add to the formula when a or b or c is selected else it should be blank)
Can you someone help on this request?
Output format : Picklist1_Picklist2_Picklist3_Picklist4_Picklist5
condition :
1. underscore should skip if any value is null or blank.
2. For picklist 1 it should only add selected values (Eg : Pickvalues : a, b, c, d, e, f : it should only add to the formula when a or b or c is selected else it should be blank)
Can you someone help on this request?
You can also use workflow to meet your requirement if you want the field to be editable.
Thanks,
Sowmya.
Were you able to achieve via formula ?
Regards,