Round-Robin Assignment formula

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:

Annotation 2020-03-31 190356.jpg

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?

Accepted answers

fmvizcaino

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

2020-03-31 Round-Robin Assignment formula.yxmd

All comments

fmvizcaino

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

2020-03-31 Round-Robin Assignment formula.yxmd

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335