How do I add a carriage return to a concatenated formula so each result is on a separate line?

use

<br>

tag worth noting however that exporting the search to csv/xls will have the literal "<br>" in it

Thanks, I tried that tag and it didn't work for me.

@Kristin M see if this points you in a direction: ‘row 1 name: ‘||{row 1 name field}||'br‘||‘row 2 name: ‘||{row 2 field}||'br‘||‘row 3 name: ‘||{row 3 name field}

@Kristin M, Ondina's example is correct. If you're still having trouble, please post the formula that you're currently using

It's not working in this formula that I'm using in a saved search with "Formula (Text)" - I don't have access to "Formula (HTML)" which apparently needs a permission I don't have: Replace(ns_concat({memberitem.name}), ',' , ' , ')

yeah, since NetSuite locked down HTML in formula(text), you can no longer use

<br>

tags in them. Unfortunately without that permission, there's no way for you to add an HTML formula field to your search, and thus get line breaks in a formula field.

I may request that permission in the future. For now, the " , " works, it's just not as aesthetically pleasing.

agreed. The tradeoff being if you export to spreadsheet, it looks worse if you can get hold of the permission, that would be easiest

Oh, good to know! I have exported it in its current state, and used ALT+ENTER to put in the line breaks.