Round Robin Systen

Thanuja K

I have 2 sheet and each sheet have 3 column with Assigned Person name so there are 4 people to whom I need to assign and they should get equal opportunity each month(overall opportunity they will get for each month should be equal). I need formula to assign people i have created sheet to count how many opportunities are getting to these people and i dont want to use any API here, can i assign through automation or any formula

please help Thank you

Screenshot (249).png

Screenshot (250).png

NicoLHC

@Thanuja K you can assing based on some critirea for example like this. =INDEX({Approver}, MATCH([Employee ID]@row, {EmployeeID}, 0))

Thanuja K

Hi @NicoLHC, Thank you for your response but, this formula won't work as per my conditions

NicoLHC

@Thanuja K of course you need to change condition in the formula ….did you try ?