Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Multi-line calculated field

cancel
Showing results for 
Search instead for 
Did you mean: 
Gareth_Chapman
6 - Interface Innovator
6 - Interface Innovator

Hi - I’d like to be able to create a calculated multi-line field. My use case is turning 4 separate (Non-US) address fields into an address block for export. I’d like users to be able to copy and paste a multi-line address block for one-off letters etc (ie without export and merge).
I have created a calculated field with the formula:
((IF({Address 1} = “”, “”,{Address 1} & ", ") & IF({Address 2} = “”, “”,{Address 2} & ", ")) & IF({Address 3} = “”, “”,{Address 3} & ", ")) & Postcode
…but I’d like to be able to replace the comma and space with a New Line or New Paragraph mark.
Any suggestions gratefully received.