Hi,

how can I randomly assign tasks evenly to user by groups restriction?

I'm able to randomly assign without group restriction with formulas Rand(), Rank(), Filter().

Capture2.PNG

However, there are restrictions for each user on what tasks can be assigned. For example, User1 can only be assigned with task from Group1, then user2 can be assigned with task from Group1 & Group2.

Hope someone can help out here.

Thanks in advance.