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
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