create past due date workflow
working in workflow to create past due notification in daily basis if date cross completion date.. if current date cross completion date then mail alert will send in daily basis... please help ...
Answers
-
If I understand correctly, @Yashwant Singh, you don't need the Current Date and Date Count columns.
Simply create a new workflow in the Automation pane, title your workflow 'Overdue Task notification' or similar. Choose the 'When a date is reached' trigger and select the Completion Date column as the Date field. Run once 1 day after; you can even fine-tune the delivery time.
Beyond crossing the Completion Date, you can add conditions such as:
- Send the notification only if a Status column is NOT marked complete
You can notify someone in a Contact List cell on that row OR someone else that is shared to the sheet, such as a manager.
Clicking on the ? mark in the Automation pane will take you to helpful tutorials/videos.
I hope this helps.
-
thanks for your response... but need daily based alert... day after 1 ,2 ,3 ,4 ,5, 6,7, ......etc
-
Hello Yashwant,
You may want to use "When a date is reached" trigger to send an Alert daily.
Within the workflow builder, with the date trigger chosen, you can select "Run Once", and then select Custom. Here it allows you to set a recurrence for the Alert. please see my below screenshot:
See more on this here: https://help.smartsheet.com/learning-track/smartsheet-intermediate/alerts-reminders
Please reach out if you have any questions
Kindest Regards
Sean
-
Hi Sean,
I followed your directions using the custom field but it says the starting date is fixed. What if i want the first trigger date to be a column date and then have an overdue task be notified everyday after the "column date"?
Thanks!
Kathy
-
Hi @KathyL
I would create 2 separate workflows: one that is triggered by the exact date in the cell, and another one that is triggered one day after that date (with a Condition Block identifying other criteria).
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives