Update QBO Invoice from editing cells in Smartsheet

Hey there, @DBS Analytics! I went ahead and merged your second post question into the original topic.

I hope you don’t mind, I did some digging into the open ticket with my friend in support and wanted to share some of what was reviewed there so far. It sounds like the original flow with Smartsheets wasn’t possible. 

 

For the workflow to work as you want it to, you need a way to grab all of the rows associated with the updated row's invoice number. For example, if the Zap triggers when you update one row, you'd need an action to find all the other rows that contain the invoice number associated with the updated row. 
 
This is important because the "QuickBooks | Update invoice" action needs all of the line items (updated or not) that you want to show up on the updated invoice. As you've experienced, mapping only the updated line item deletes all others.
 
I hope this is making sense! 
 
In short, the workflow isn't possible with Smartsheets. But we could potentially create a workaround if you're willing to go that route. 

 
A workaround would entail adding something like Google Sheets to your workflow since it has an action that lets you find multiple rows based on certain search criteria. This isn't an official recommendation of Google Sheets over other apps, just a suggestion that might enable your workflow. 

The recommend setup from there looked like:

[...] instead of using Smartsheet, the info should be in a Google Sheet. Then the Zap would be set up as below:

• 'New or Updated Spreadsheet Row' in Google Sheets trigger
• 'Find Many Spreadsheet Rows (With Line Item Support)' in Google Sheets. This can find a maximum of 10 rows. In this step, select the invoice number column as the lookup column and map the invoice number from the trigger as the lookup value. This would then return all the rows (maximum of 10) on the spreadsheet that has that invoice number
• 'Find Product(s)' in QuickBooks Online to search for the products from the 'Find Many Spreadsheet Rows (With Line Item Support)' step. This would return all the product IDs
• 'Update Invoice' in QuickBooks Online to update the invoice. Here, in the 'Product/Service' field, map the product ID from the 'Find Product(s)' step

Which brings us to your second question:

I have created a zap using googlesheet “Update Row” as my trigger, then used formatter Line itemizer (becasue googlesheet doesn’t appear to have line item support) but I not doing it correctly and keep getting error:

The tip from support looked like this:

It looks like you may have gotten stuck on the Line Itemizer step, is that right?
 
If so, it looks like you were just slightly off with the structure you wanted with the line items. you can move "line" over to the Group Name. This will be the parent field. You can then add each property as an individual row of this Line Item properties table:
 

I hope having it laid out in this way helps!

It’s also worth noting it could be also be worth consulting with a Zapier Expert at this time! We’ve got great minds in Community and it’s possible someone will come through with some magic✨. If you’re on a time crunch and/or would prefer not to fuss though, I’d highly recommend looking into hiring an Expert. 🙂