Stump the Panel

SharePoint QA

Stump the Panel » Business Problem Statements: SharePoint Designer Workflow Solutions

1. 

   Richard Surgener
   Member

   Is there a way to send an alert when a project task due date has expired without it being completed/changed? I have looked at the options to send an alert within SharePoint but don't see how to alert someone that a task has exceeded the due date without it being completed. The alerts seem to be designed for when something changes but what happens if nothing changes and the date expires? Not sure if this is a workflow thing or not. Thanks, Rich

   Posted 2 weeks ago #
2. 

   pagalvin
   Moderator

   A variation of the solution described here could work: http://sharepointmagazine.net/technical/development/the-dog-ate-my-task-use-sharepoint-designer-to-email-daily-task-reminders

   Posted 2 weeks ago #
3. 

   Richard Surgener
   Member

   Thank you. This is a great start. Although I am still a bit stumped as to how to identify that the due date has exceeded today's date and that the task status is less than complete. Any ideas?

   Posted 2 weeks ago #
4. 

   eric
   Moderator

   That would just be 2 condition statements in a step of the work flow. The due date and status are going to be fields to reference so you'd just do 2 data comparisons like:

   If % Complete is less than 100
   and due date is less than today

   Do something

   (taken from a stock tasks list)

   Posted 2 weeks ago #

RSS feed for this topic

Reply

You must log in to post.