+ Start a Discussion
Donny.ax1663Donny.ax1663 

Populate Opportunity Field based off of 1 text field and 1 pick list

Hello,

 

I am still learning formulas in Salesforce.  I have a question about populating a custom field with 2 different values.

 

What I am trying to accomplish is, I want my "Ship Sku" field to be populated by "Quantity__c" (a text field) and "SKU__c" (Picklist field).  So if a rep enters "2" in the quantity field and "GREENC" in the Product Sku field the "Ship Sku" field would reflect "2:GREENC".

 

Is this a possibility?

 

Thanks in advance,

 

Donny 

Best Answer chosen by Admin (Salesforce Developers) 
klamklam

Create "Ship Sku" as a formula field that returns Text and use this formula:

Quantity__c & ":" & TEXT(SKU__c)

 

All Answers

klamklam

Create "Ship Sku" as a formula field that returns Text and use this formula:

Quantity__c & ":" & TEXT(SKU__c)

 

This was selected as the best answer
Donny.ax1663Donny.ax1663

Thank y ou! Exactly what I was looking for!!