Hi ,
try this
Title
Use this for Ticketno
|
Number
|
HelpDeskUser (person or group
|
Assigned
(Boolean)
|
Modified
|
1100001
|
1
|
USER A
|
YES
|
2:10:01 PM
|
1100002
|
2
|
USER B
|
YES
|
2:10:02 PM
|
1100003
|
3
|
USER C
|
YES
|
2:10:03 PM
|
1100004
|
4
|
USER D
|
YES
|
2:10:04 PM
|
1100005
|
5
|
USER E
|
YES
|
2:10:05 PM
|
1100006
|
1
|
USER A
|
YES
|
2:10:06 PM
|
1100007
|
2
|
USER B
|
YES
|
2:10:07 PM
|
1100008
|
3
|
USER C
|
YES
|
2:10:08 PM
|
1100009
|
4
|
USER D
|
YES
|
2:10:09 PM
|
|
|
|
|
|
Step 1 : Loop through the last modified 5 items in asc order the list (in the above list User E)
And the number is 5 then
Set Assigned = “Yes”
Set Number = 5
Based on the Number pick the User using lookup column or from other list using Query list
Then assign in to that user .
Title
Use this for Ticketno
|
Number
|
HelpDeskUser (person or group
|
Assigned
(Boolean)
|
Modified
|
1100001
|
1
|
USER A
|
YES
|
2:10:01 PM
|
1100002
|
2
|
USER B
|
YES
|
2:10:02 PM
|
1100003
|
3
|
USER C
|
YES
|
2:10:03 PM
|
1100004
|
4
|
USER D
|
YES
|
2:10:04 PM
|
1100005
|
5
|
USER E
|
YES
|
2:10:05 PM
|
1100006
|
1
|
USER A
|
YES
|
2:10:06 PM
|
1100007
|
2
|
USER B
|
YES
|
2:10:07 PM
|
|
|
|
|
|
Step 1 : Loop through the last modified 5 items in asc order the list (in the above list User E)
And the number is 3 then
Based on the Number pick the User using lookup column or from other list using Query list
Then assign in to that user .
Set Assigned = “Yes”
Set Number =3
Assigned field is optional though
Hope this helps ..