Tuesday, February 13, 2018

yogi_Set Up Invoice For Printing From A Google Sheet With Multiple Lines

Google Spreadsheet   Post  #2366

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-13-2018

question by: Liesl Roesch
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/vbF92YHX84Y;context-place=mydiscussions

Print an Invoice from a Google Sheet with multiple lines

I am looking to create an invoice, to be printed - page break by name, that will summarize by name the items purchased and sum the amount owed. 


I'd like the invoice to be something like this:


Name:
You purchased the following items:
(dynamic list based on spreadsheet)

The total amount you owe is (Total)

Your help is appreciated.