Smart Sheets Merge with Google Docs

billing10428

HI 

I started to use the merge Feature

 

to get my sheets into a Proper form so i can send it as an invoice to my customer  

(as Per link Below ) 

https://www.smartsheet.com/videos/work-smart-webinar-merge-data-from-smartsheet-into-google-docs

 

but my issue is  that when im trying to send it in 1 pdf / 1 form for Mutiplel Row lines 

 

since im not going to send to my customers 10 Invoices in 1 paticular date 

 

Since i have sometimes Multipel items that needs to be in 1 form 

 

So My Question is Can i merge in Mutipel row lines into 1 Invoice PDF Page ?

 

 

J. Craig Williams

Billing -

 

Short answer, no.

Merge takes one Smartsheet row per document.

If you select 10 rows, you get 10 documents.

 

Depending on how your data is structured / formatted, you might use a trick I am sometimes (not always) able to employ and use the JOIN() function.

 

I have a row (I indent so it becomes a parent) that is used to consolidate information from several rows and then that is the one that gets used by Merge.

 

Hope that helps.

 

Craig

billing10428

HI Craig,

is thir any other Programs like The google doc Merge that i can export into a professional form so it looks like an invoice ?

 

and i can send it Directly to my customer ?

J. Craig Williams

I haven't found one I like completely yet.

 

Craig

Dana Schuler Drummond

Well, it didn't take long to see that I'm not the only person with this question. Hopefully SS will help us out and create this feature. It would really help me out. 

Ivan Borisov

Looking forward for the same solution! It would be very usefull for us.