Hello,
I’m trying to write out some lines in a table into text using FormulaMap()
Right now they all show up as a list, and I was trying to figure out a way to line break between the list. Any thoughts? Concatenate(Value, “\n”) etc aren’t seeming to work
Character(10) generates line breaks.
Using Concatenate(CurrentValue, Character(10)) or CurrentValue + Character(10) in FormulaMap are both not working. The + is leading to crazy values (grid-843…), and the Concatenate is leading to commas on a second line vs actually moving the next item to the next line. Any thoughts?
Screenshot?
I always use Concatenate(), never +.
Hard to see the , that is there on the first one with the formula, attaching both
Second where you can see the comma
Does appending your formula with .BulletedList() give you a satisfactory result?
@Chase_Schwalbach
Actually, I think that might be a bug.
@mallika Here’s some quick testing:
BulletedList did fix it! But still seems quite buggy 
We’ve been here before, @Ander => Escape characters?
It only seems to work inside a cell at the moment, and the team are aware of it.
Wow, I had no idea this existed. Thank you!
Hey all, just wanted to chime in and share that we have a new formula specifically for generating new lines: LineBreak(). It should definitely be smoother and more straightforward than the older solution discussed here. But let us know if you run into any questions with it 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
