+2
Hi,
Can anyone tell me if it is possible to create a site workflow to run against a list which will query the list for items which have a field "task stage" set to value "Review 1".
And if in 5 days time the value is still "Review 1"
we then need to email the manager to notify them that a certain list item has being set to "review 1" for 5 days.
+11
Hi Stephanie,
Yes, you can create a site workflow for this purpose. In your main list, you need a column to compare against. For e.g. create a date column in the list "review assigned date". In the site workflow, create a date-time variable call varAssignDate and set its value to -5 days i.e. date that was 5 days ago. Query list where task stage is pending or Review 1 and review assigned date is equal to workflow variable varAssignDate. Send the notification to managers then. Hope this helps.
+2
Thanks Kapil, I have it working now 
+11
Glad it worked. Please mark the suitable response as answer to help others.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.