How do I add line items from Quickbooks into SmartSheet as multiple rows instead of a full string with commas?

  • 15 April 2022
  • 1 reply

I am looking to take QuickBook invoice and put each line on a new row in Smartsheet. 


I have used the utility “Line Itemizer” and I got the data string to come in and separate.  


Only thing I need help with is how to add this to SmartSheet in multiple rows. Right now it just adds the full string with commas from the utility. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @TroyBD 

Good question and better name!

Try Looping to handle line items: