Email Report Summary of Tasks at risk - ONLY IF 1 or more tasks are "At Risk"
![Joechaptaylor](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi,
I have a colum "at risk" in my sheet, id like to set up a report that sends to summarise all items at risk, i have the report set up this is really simple and no issue.
How do i go about restricting the report to only send if 1 or more items meet the criteria, rather than sending a daily blank report and me having to check each day to see if there are any?
Answers
-
The report notification doesn't give you the option to do what you've described. Could you create a notification from the source sheet instead, which would give you the option to only send the items at risk if there are 1 or more?
-
My worry with the above, is it will only send an email as this item is found "at risk" once.
It will then be missed in future emails/reports and runs the risk of being missed completely!
-
You can set up the notification to run daily. Change the trigger to When a date is reached, click the dropdown next to "Run once" and select Custom. You can set it to run daily with the condition that the item is "at risk". That will send any items that are at risk, even if they have already been sent in the past.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives