I have five tasks that need to be completed each week, and five people available to complete the tasks. Each person wants a different task each week at random. Currently, I'm trying to accomplish this by having a "chores" list and a "chore assignment" list. I also have a card somewhere titled "chore performers", and each of the five people is a member of that card. I have an automation rule that says "when a card is copied from the list 'chores' to the list 'chore assignment', copy a member in turn from the card 'chore performers'." (If I use "copy a member at random" instead of "in turn" then it does random selection with replacement, meaning that a person might get more than one chore if I did that). I also made a board button that says "Shuffle the cards in the list 'chores' and copy each card from the list 'chores' to the list 'chore assignment'". If I click the button, all works as intended: the cards get shuffled, they get copied over to the assignment list, a member is added, and everything is randomly distributed without replacement. However, if I now make a calendar rule that says the same thing as the button ("Every Friday at 7:00 pm, shuffle the cards in list 'chores', and copy each card from the list 'chores' to the list 'chore assignment'"), then this doesn't work. It copies the cards over and assigns members, but they are always in the same order and so people always get assigned the same task. I also tried scheduling each step at a different time (e.g., at 7pm shuffle the list, at 7:05pm, copy the cards to the new list, etc), and that didn't seem to help. It's almost as though when the calendar automation copies the cards, there's some sort of default sort order it's using instead of the order of the cards in the original list. The bottom line is, how can I automatically schedule a random 1-to-1 assignment of people to tasks like this? It seems like this should be like a core thing people are trying to do with Trello, so I just can't imagine why this seems to be close to impossible...
