Smart Sheets Merge with Google Docs

billing10428

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 ?

Find more posts tagged with

Comments

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.