Populating external Reports with Smartsheet Data

Scott Rae
Scott Rae ✭✭✭✭✭✭

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

Best Answer

  • Scott Rae
    Scott Rae ✭✭✭✭✭✭
    Answer ✓

    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

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    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, [email protected])

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Scott Rae
    Scott Rae ✭✭✭✭✭✭
    Answer ✓

    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å
    Andrée Starå ✭✭✭✭✭✭

    Excellent!

    Happy to help!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.


  • 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å
    Andrée Starå ✭✭✭✭✭✭

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.