Generate documents from parent and children rows


Is it possible to generate one document from multiple rows?

Best example I can think of would be an itemized order with multiple items in the order - how can you list all order items from that parent row (order number) with the item ordered [qty, price, detail information] on the children rows? Having columns to fill on the same row not feasible as we frequently have more than 80 separate items to list with qty, price and other details and would max out the sheet without listing all the orders in process.

It would need to expand to multiple pages as needed (2 or 3 common) but still be only 1 page on a frequent basis.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!