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

Automatic Unalignment of Dashboard Widgets
Is anyone experiencing their dashboard widgets automatically being unaligned or they have moved a bit from your last save? I am the type where I like things clean and aligned. Some may say it's OCD. In Dashboard, this can mean the edges of my widget line up, each section is centered or same purposed widgets are the same…
How to restrict Form responses to data existing in the related Sheet
I am trying to create a Form that requires the user to supply information related to any item existing in the Primary Column. If I pull that existing field into my form, the user entry is a free-form field and I can't figure out how to restrict it (other than validating by data types). If I add a new field with a dropdown…
Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…