In a "Customer" database, based on a YouTube video, I created a formula field that contains street address + City + Province.
I would like to have this "formatted"; in other words, street on one line, City and Province on another line, etc.
Is there a way to insert a "carriage return" in the formula?
Is this the way to achieve what I want?
Try it like this:
street + "
" + City + " " + Province
In other words: you add a carriage return ba giving a carriage return in quotation marks.
Please note: Your Formula will return 'undefined' until you 'Save Changes', at which point the new text formatting will appear. Lots of trial and error discovering this one.