Forum Discussion

EvanBohan's avatar
EvanBohan
Qrew Cadet
5 years ago

Assign 1 of 4 users to a specific Record type? Make it even/fair?

Okay so I have a team of 4 that pick up specific record types categorized by a drop down.  I want to apply an even split to the 4. For instance the record type (category) might be "complaints". ...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
That should be perfect, what is the problem?

If you have some data in your app and run a summary report by Assignee, you will find that while the allocations may not be equal they will be very close to equal.
EvanBohan's avatar
EvanBohan
Qrew Cadet
5 years ago
It is random so everyone has a 1/4 chance of being assigned.
I was curious to know if there was a method for perfect split based on conditions, that's all. 

so instead of "close to equal", just "equal"

And thanks for your reply!