Hi,
Suppose 4(four) image cards and 4 persons
I would like to distribute the cards to each person.
Then every try the cards should be distributed randomly to random person
But when I used randbetween() formula, cards were moved randomly but always with same person.
Help me out @@
You probably need to share more details about what you’ve already implemented in your app in order for others to provide advice.
One point to confirm is whether you’re actually recalculating the column that uses the RANDBETWEEN expression to assign cards to people. If nothing triggers recalculation of those rows, then whichever number was previously calculated for each row will never be modified.