Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Smart Sheets Merge with Google Docs
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 ?
Comments
-
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
-
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 ?
-
I haven't found one I like completely yet.
Craig
-
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.
-
Looking forward for the same solution! It would be very usefull for us.
