How to get list of assets to PDF from one cell

Volodymyr L · 11/07/22

Good day

I get the list of assets using this awesome CHAR (10) thing

=JOIN([Asset name]15:[Asset name]17; CHAR(10))

Now i want to get thw list of assets to my PDF using some control of where it should be

( like 2 3 4 row )..

And how to put QTY, HOURS and AMOUNT to each cell in PDF?

Genevieve P. · 11/10/22

Hi @Volodymyr L

Document builder maps cells to fields in a 1:1 relationship. This means that even though you have multiple lines within one cell, that entire cell would need to be mapped to one field in your PDF document. There isn't a way to parse out the combined values into multiple fields in the PDF.

Here's more information on Document Builder:

https://help.smartsheet.com/learning-track/smartsheet-advanced/document-builder

Cheers!

Genevieve