Scheduled Reports as Attachment - Do not send if blank

Is it possible to stop a scheduled report attachment from sending if the report has 0 results? Our recipients can start to ignore the reports because half the time they receive it, it is blank. So if they don't look at it because they think it is blank half the time, they miss the important report when it may actually have some items within the report to review.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

Emily D

It would be nice if there was a funcationality on the send report as attachement sheduling options to have a re- occuring reports that send only when there are rows in the report to send. When the report is blank it doesn't send an email.

Righ now I have weekly updates from a report for overdue items and the email attachement goes out regardless if there are rows in the report or not. So emails go out some times blank which will cause those receiving them to get email fatigue and the email will be ignored most likely. THere is no other option in smart sheets to create a report or notifications in one email.

Kristy Factor

Or even better idea would be an option to still be able to send the email, but be able to input a different message when the report is blank. So when the report has results, send an email with specified message with attachment and if the report is blank send an email with a different specified message. This way the recipients aren't confused if they receive nothing and the scheduled message will populate with our blank report message option we input. That way I could have one that says "See attached report…." and one that "No items to review this week…" or whatever the customized message might be.

Quick Links

Trending ideas

Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.