Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Emailing reports, except for when blank
Options

GeorgeWaite
ββ
I have a report pulling data from several sheets inside my workspace. Essentially it emails the report as an attachment every morning at 9am to my team and lists out open project needs.
Β
The question is there are some days when the report is blank (ie. no open project needs). Is it possible to:
- not send an email if report results are blank/empty/null
- to send an email but no attachment
- to modify the email so that it sends but says a custom message like "report found no active needs for today"
Β
It would be great to have more options when generating and automatically sending reports out. Let me know if I'm missing anything or if this could be a feature request. ThanksΒ
Β
Comments
-
Hi George,
There currently isn't a way to conditionally email reports (ex. only send when not blank) or to conditionally modify the email body/subject.
When you have time, please submit a Product Enhancement Request via Quick links on the right of the community site.
This discussion has been closed.