Help

\n in SUBSTITUTE is not working

Topic Labels: Formulas
699 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kenny_Purnomo
5 - Automation Enthusiast
5 - Automation Enthusiast

I have followed this Video Structuring Line Item Detail - YouTube in 8:30

But i cannot get the PO details as he got (multiple rows)

My formula SUBSTITUTE({Rollup to Text},“Item”,"\nItem")
does not return the correct output.

Please help

1 Reply 1

More details are required before we can effectively help. Specifically, more details about the steps leading up to the formula: field names, field types, example output, screenshots, etc. The more details you can provide the easier it’ll be to help. The formula looks good on the surface, which is why I feel that the problem lies in some step before the formula.