Separating rows in cells when generating pdf document
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
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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!
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives