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.
Re: Task Alerts
I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up
To do this I use a form to add new tasks and then included the following columns in my sheet so;
- a date column for when activity is due (future dated when added)
- a formula column that does Today-date column (I've done this so that this column changes each day which I think is required to prompt the alert which detects when it is 0 or negative)
- a done tickbox column so that done items are not included in the alert each day.
Has anyone done something similar - I have included the alert as image below - my problem is that some days it comes through but other days it doesn't and this causes problems.
Thanks in advance for your help.