I am trying to merge different fields into one field in my CRM app
Currently I am only able to have my address fields merge to display
'123 Main St' 'New York' 'NY' '11111'
But I would like to not have the ' between each field
The formula I used was
'${Leads.Street} ${Leads.City} ${Leads.State} ${Leads.Zip Code}'
I have also tried
${Leads.Street} ${Leads.City} ${Leads.State} ${Leads.Zip Code}
'${Leads.Street}+${Leads.City}+${Leads.State}+${Leads.Zip Code}'
${Leads.Street}+${Leads.City}+${Leads.State}+${Leads.Zip Code}
"${Leads.Street}+${Leads.City}+${Leads.State}+${Leads.Zip Code}"
But I have had no luck with these formulas