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

Β 

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.