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

GeorgeWaite
GeorgeWaite ✭
edited 12/09/19 in Archived 2017 Posts

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 

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    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.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories