Separating rows in cells when generating pdf document

Tamara

Is there a way to keep the rows clean and separate when you generate documents.

In the cell I use "alt enter" to separate the information I type in.

In the background, I have several formulas working to populate cells that allow me to print a pdf correctly. The information is correct, it's just one big long scrunched up piece of information. See the example below.

Should Read Like This:

Row 1: Job Number Job Name Qty Serial Number

Row 2: Item Number Customer Color Code

Formula Reads

=[JobNumber]@row+[JobName]@row+[Qty]@row+[SerialNumber]@row+[Item Number]@row+[Customer]@row+[Color Code]@row

Result of the formula:

Job Number Job Name Qty Serial Number Item Number Customer Color Code

Problem being is there are sometimes several rows of information in the box. So some Job Numbers end up with another job number's information below it.

Andrée Starå

Hi @Tamara

I hope you're well and safe!

I haven't tested this yet, but you could try to use the CHAR function and CHAR(10) as a line break.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Tamara

I hope you're well and safe!

I haven't tested this yet, but you could try to use the CHAR function and CHAR(10) as a line break.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tamara

Andree, OMG! This works beautifully! Thank you so so much! I have been struggling trying to find work arounds. I am so thrilled! Thank You, Thank You!

Andrée Starå

@Tamara

Excellent!

You're more than welcome!