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