Send A Daily reminder based on Status field

First off thanks for this great community. Being new to Smartsheet, this has been a great resource to help with the deep dive. I would like to report so far so good!!
I have been digging and looking into the process to send a daily email to update staff on what is left on a task list with a status not = completed.
The problem I am having is trying to figure out how to trigger this email-based field and not on a date of some sort. It has to be right in front of me but for some reason, I can not figure it out. ANY help would be great and would be considered a present straight from SANTA himself. Thanks for your time!
ZC
Best Answer
-
The Automation 'Alert Someone' with the trigger set to when a date is reached. Then change the setting to custom which allows you to change it to check it daily at a specified hour. Next, the condition would be status column 'is one of' Not Completed. You could customize it further if you have a name column and add an additional condition where name = "John Doe", Alert John Doe..
Answers
-
The Automation 'Alert Someone' with the trigger set to when a date is reached. Then change the setting to custom which allows you to change it to check it daily at a specified hour. Next, the condition would be status column 'is one of' Not Completed. You could customize it further if you have a name column and add an additional condition where name = "John Doe", Alert John Doe..
-
Jeff i owe you a beer next time you are in Montana!!!! The Custome Date option is what did it. Thanks so much!!!
-
Awesome!! Glad I could help you out!!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives