Random Select Formula?

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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!