Hi
To generate invoices for my orders in Google Docs, I need to add the rows from my Google Sheets table. First, I performed a “Search Rows” to generate invoices based on the shipped status. The problem is that sometimes I have several rows because multiple products need to be included in the invoice. I’d like to generate the invoice for all items and add them to Google Docs. However, I’m having trouble calculating the subtotal, total VAT, and grand total.
Really appreciate your help