I am currenlty trying to find a way to assign task based the the week of the month.
Week 1: User 1
Week 2: User 2
Week 3: User 3
Week 4: User 4
Based on the week i will need to assign the task to proper user.
Conditional Task Assignments
+23- Nintex Partner
Hi,
Create a Calculated column that returns the week number of the year.
This MSDN post gives you the calculation.
https://social.msdn.microsoft.com/Forums/sharepoint/en-US/fdbbcf4d-a63c-4f09-991a-9000bcabb267/sharepoint-converting-a-date-to-a-week-number?forum=sharepointdevelopmentprevious
In your workflow read this column to get the week number.
Then do a modulo 4 to find out the remainder.
If its 0 assign to user1, if its 1 assign to user 2........ if its 3 assign to user 4.
Create a Calculated column that returns the week number of the year.
This MSDN post gives you the calculation.
https://social.msdn.microsoft.com/Forums/sharepoint/en-US/fdbbcf4d-a63c-4f09-991a-9000bcabb267/sharepoint-converting-a-date-to-a-week-number?forum=sharepointdevelopmentprevious
In your workflow read this column to get the week number.
Then do a modulo 4 to find out the remainder.
If its 0 assign to user1, if its 1 assign to user 2........ if its 3 assign to user 4.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.