Random Select Formula?

Nicole Hodges

Hello everyone!

Does anyone know if it is possible to randomly select a row? My use case is a drawing for tickets. I want to be able to have people fill out a form and then use a formula to randomly select a winner. I would use "Auto Number" column to identify the person.

Looks like it can be done in Excel - =INDEX($A$2:$A$10,RANDBETWEEN(1,COUNTA($A$2:$A$10)),1)

Appreciate any help!

Paul Newcome

Smartsheet does not currently support "random", but I have seen a few other people ask for it over the years. Feel free to Submit a Product Enhancement Request when you have a moment.

Paul Newcome

Smartsheet does not currently support "random", but I have seen a few other people ask for it over the years. Feel free to Submit a Product Enhancement Request when you have a moment.