function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
shan jakkulashan jakkula 

Formula field to concatenate two text fields in to one text field

Hi  ,

I have two text fields ( Billing Street and Billing City), i need to combine those values and show it as a formula field

Billing Street = myStreet
Billing City = myCity
output of my formula field will be like....
Address( formula Field, return type is text) = myStreet,myCity

please Help anyone to achieve this.

thanks in advance
 
FearNoneFearNone
Is Billing Street & "," & Billing City not working?
shan jakkulashan jakkula
sorry my bad, those are custom fields
billing_street__c and billing_state__c
sfdcMonkey.comsfdcMonkey.com
hi shan
use below formula 
billing_street__c + ',' + billing_state__c
let me inform if it helps you
thanks
 
Nishant Dubey 7Nishant Dubey 7
In formula field , choose "Output type" : Text and then use the formula Like : billing_street__c +  billing_state__c or need a space between them billing_street__c + ' ' + billing_state__c