How to use formula field fo Picklist value?

Formula field: We will display value based on Picklist value in formula field from parent object.

For example: We have two address in Account level and user can select any of these address and display based on selection. First we will create full address field as formula field then create picklist field for address selection.

Let’s start:

  • Click Setup
  • Select Object Manager 
  • Select Accounts
  • Select Fields & Relationships
  • Click New
  • Select Data Type as Formula
  • Click Next

  • Create Formula field:
    • Name: Full Billing Address
    • Formula: BillingStreet & ” , ” & BillingCity & ” , ” & BillingState & ” , Zip Code ” & BillingPostalCode & ” , ” & BillingCountry
  • Create Formula field:
    • Name: Full Billing Address
    • Formula: ShippingStreet & ” , ” & ShippingCity & ” , ” & ShippingState & ” , Zip Code ” & ShippingPostalCode & ” , ” & ShippingCountry
  • Create Picklist field:
    • Name Select Address
    • Value Billing Address
    • Value Shipping Address
  • Create formula field:
    • Name: Address
    • Formula: CASE(KTapps__Select_Address__c,
      “Billing Address”, KTapps__Full_Billing_Address__c ,
      “Shipping Address”, KTapps__Full_Shipping_Address__c ,
      “”)

Leave a Reply