Hi

Wouldn’t it be easier and fairer to just rotate staff through the different tasks? If you use a genuinely random system, you’ll find some people repeating tasks and some seldom doing some. Also, if you have more staff than roles to fill, a random system will not distribute the days off equally in the short term. These things will average out in the long term, but staff may not see it that way if they get several days without work.

Anyway … one way to randomise task allocation and ensure there is no duplication of roles would be to put random numbers next to each name and then allocate tasks according to the rank of those random numbers. So the highest random number is reception 1, the second highest is reception 2, and so on. Each time you refresh the sheet the random numbers and their ranks will change, allocating that position to different people.