Automated Workflow for Forms and Reports

I created a form to collect data from users (while at the same time protecting my sheet). I need to collect data from users on a monthly bases, and I'd like to be able to send the Form I created at the beginning of every month.

I also have a Report that I'd like to send out to managers at the end of each month. I know can always share the Report with the managers, but many of them simply forget to check back. An Automated Workflow for my Report would be the ideal solution.

Is there a way to set something up in Smart Sheet to Automate sending the Report and Form?

Find more posts tagged with

Forms

Reports

functionality

Comments

Andrée Starå

Hi Angelo,

Form

You could set up a Workflow that sends out an alert with a link to the form.

Report

Same as above for the form, or you could set up the report to Send as Attachment with recurrence.

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic week!

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!

Angelo Cordero

Hi Andree,

Thanks for commenting!! I thought about sending the Report as an attachment. The problem there is that I can only send it as either a PDF or an Excel file. I end up losing the ability to have managers provide updates to what their employees are logging.

I didn't think of your suggestion for the Form, so I tested it out by sending an alert to myself with the link. The problem I ran into was that the Alert includes a very prominent link to the actual Smart Sheet at the very top. The purpose of me creating the Form was to avoid users from having to go into a very complicated sheet in the first place. If I could find a way to disable that prominent link to the Sheet at the very top of the Alert, your suggestion would be PERFECT.

Thanks!!

Angelo

Andrée Starå

Happy to help!

You can add the URL to the Recurring report or as a reminder instead (I think it doesn't show the prominent link as the others)

Would one of those options work?

If not, I'd recommend using a 3rd party solution/integration. Is that an option?

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…