Another day, another Google Sheets (Excel-like) challenge. :)
This time, I have a column of team names. The team names may or may not have an entry code associated with their team.
I spent nearly 2 hours searching the internet for answers. It seems that no one has tried to do this with just formulas. I found a few examples, but they required scripting. :(
The challenge is that I wish to automatically assign a reviewer (from Reviewer List
column) if the team has an entry code. But in doing so, I want to assign a reviewer round-robin style, so that each reviewer is assigned approximately an equal number of teams.
Please see example sheet:
The way I am currently doing this isn't very smart, names are not used sequentially (and round-robin), every time there is a value in the Shared Entry
column. What I wish to see is what is shown in the Expected Results
But to accomplish this challenge, it will need to work in Google Sheets, use only formulas, and work without add-ons.
Is this even possible?
Thank you so much