How to get list of assets to PDF from one cell

Volodymyr L

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.

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

Volodymyr L

https://community.smartsheet.com/discussion/comment/350787#Comment_350787

Hi, i found solution

=JOIN(COLLECT({Payment_Check Tasks}; {Payment Check Team}; =$Artist@row; (CHAR(10) + CHAR(10)))

And then you have to put the flag of the APPLY COLUMN in PDF FORM settings

Then it works. So, it`s not just Smartsheet problem, you have also check the PDF Form settings

And it works perfect. BUT. i have another problem and i`ll create new thread

So, the list works as ONE CELL