I have an automation set up to assign records (using a User field "Assignee") based on the workflow-stage (single select field "Stage"). It assigns a user by finding which records in another table "Assignments" match the "Stage" value in a "Responsibilities" field. As such, if 4 users in the "Assignments" table have the value "Stage 1" in the "Responsibilities" field, when the field "Stage" for a record in the main table changes to "Stage 1", these 4 users are assigned the record in the "Assignee" field.
However, I want to implement an even distribution of tasks. So, carrying on from the previous example, if 20 records move to "Stage 1", then each of these 4 users should be assigned 5 records. Any help on this would be greatly appreciated!
