Would someone be able to help me with a formula to randomly pick a winner accounting for the number of times they are “entered” in a draw. My table is tracking exercises where students are awarded an “entry” in the draw for each workout or challenge ...
I have a single select field “Day of Week” with Mon, Tues, Wed, etc, etc.
I would like to be able to sort my table in that order - but it seems like we only have the option to sort alphabetically (which results in an incorrect order). Once this tabl...
Thanks for your time on this Jonathan. From what I’ve googled, I believe that’s the correct way to weight the entries. I’ll have to spend some time learning to use the scripting block, but understood your code well enough. Thanks! I’ll post back once...
Well somehow this is now working… (EDIT: and now it isn’t…) :tired_face:
I don’t know what I did differently, but I toggled the “show cutting lines” to on, and it worked - multiple records per page. I turned it back of and it still worked…
As note...
I can not get this to work the way you’ve done and would love some help please.
example data looks like this…
Events | Students List
event 1 | student a, Student b, student c
event 2 | another list of students
etc | ...
