Separating rows in cells when generating pdf document

04/08/21
Accepted

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.

Best Answer

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    Accepted Answer

    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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    Accepted Answer

    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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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åAndrée Starå ✭✭✭✭✭

    @Tamara

    Excellent!

    You're more than welcome!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.