Round-Robin Assignment formula

[GoldenDesign04]

I have a workflow that generates tickets for investigation by QC techs, this generates daily, seven days a week. It contains a few Null() fields that will be worked on by the techs. 

I've used the formula: DateTimeFormat([DateField],"%u") will give you the day of the week where Monday = 1 and Sunday = 7

To find the day of the week that the report generated. 

I have a table that has the Techs names and the weekday they are scheduled to work:

I need to have it find the day of the week and then assign techs into the Analyst column until filled.

Any suggestions on how to accomplish this? 

[fmvizcaino · Accepted solution]

Hi @GoldenDesign04 ,

I've create an example based on 4 analyst but you can configure the number as you desire.

Take a look and let me know if this works for you.

Best,

Fernando Vizcaino

[GoldenDesign04]

Fernando this looks very very good. It was nearly perfect! I had to account for varying number of techs on each day. Easy enough when you gave such a good formula to start!

Thank you

[bkro86]

How do you get it to change based on the number of analyst being different each time its run?