Hi all,
I am working on an automatic work roster to help spread workload over my team members.
With 5 team members present I can generate a list of tasks in the following form, normally the team has 7 members.
The spreadsheet currently tells me how many people I need on which task
Task 1 - 2 people
Task 2 - 1 "
Task 3 - 0 "
Task 4 - 0 "
Task 5 - 2 "
I need to spread this randomly over a list of team members that are present.
The expected result would be something in the form of the following:
Person A - Task 1
Person B - Task 5
Person C - Task 2
Person D - Task 5
Person E - Task 1
As an additional difficulty, I'm using google sheets to do this.
Thanks for all help in advance
Bookmarks