Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

\n in SUBSTITUTE is not working

Topic Labels: Formulas
295 1
Showing results for 
Search instead for 
Did you mean: 

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.