Populating a PDF from smart sheet rows, instead of columns


Hi there. I am creating an intake form, that captures data "vertically" vs. horizontally. The data is collected this way for both esthetics and ease of use. So, for example, I have a single column, that collects different types of data, e.g.

Column 1

row 1 Your name

row 2 Their name

row 3 Someone else's name

What I would like to do, is map each row individually, to a different field in a PDF. Document Builder does this, however, requires your data be in separate columns, vs. all of your data in a single column, and then mapping rows to PDF fields. So in my example above, I would map Your Name to a field, Their name to a separate field and Someone else's name to a third field in the PDF.

Does anyone know of a way to accomplish this?


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi Ian, I don't think that's possible currently. I suspect many things will work better for you if you construct your data in rows instead of mixing data in columns. Can you use forms for data entry to make it more visually appealing?


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.