Populating external Reports with Smartsheet Data

Scott Rae · 02/13/20

Hi,

Is there any way that I can export my data from smartsheet so that it automatically populates/merges into a template that i have (word document)

Thanks in advance,

Scott

Scott Rae · 02/13/20

Hi @Andrée Starå ,

Ive realised that using the export to excel and then mail merging works very well so i think i will go with that method.

Thanks for your help though

Cheers,

Scott

Andrée Starå · 02/13/20

Hi Scott,

There might be a way. Does it have to be in word?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Scott Rae · 02/13/20

Hi @Andrée Starå ,

Ive realised that using the export to excel and then mail merging works very well so i think i will go with that method.

Thanks for your help though

Cheers,

Scott

Andrée Starå · 02/13/20

Excellent!

Happy to help!

Andrée Starå · 02/13/20

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Evan Smith · 11/18/20

https://community.smartsheet.com/discussion/comment/239891#Comment_239891

Hello! thanks for the insight; we are new Smartsheet users, and need to do the process that Scott Rae is describing, approx. daily.

We will effectively use smartsheet to capture "commitment" records for contractors, summarize these into "PO reports" for each contractor, and then issue POs for each contractor.

So - could we put in place a daily process of exporting to excel all smartsheet commitment records for all contractors; import/ mail merge (in a Word template? OR is there a better/ more automated application to use?) and uploading the generated PDFs to docusign?

very interested to hear others' ideas on this. thank you...

Andrée Starå · 01/04/21

Hi @Evan Smith

I hope you're well and safe!

Excuse the late response.

Crazy times and I missed coming back to you.

Have you solved it, or do you still need help?

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Populating external Reports with Smartsheet Data

Best Answer

Answers

Categories