Way to create a random sample sheet?

Options

I am looking for a way to pull ten rows of data (randomly) into a separate sheet for auditing purposes. I understand there is no RAND function, like in Excel, and I'm struggling with a creative way to gather this random sample from our main data set.

Answers

  • L_123
    L_123 ✭✭✭✭✭✭
    edited 11/11/20
    Options

    If you want to generate random numbers subtract a created (time/date column) from modified (time/date Column), and take the 5 right values from that.

    =value(right(modified@row - created@row,5))

    Add new rows by submitting information via form, and you have "Random" numbers that would be fairly difficult to manipulate. If you want to simplify the number of responses just use floor and or ceiling to round the responses to the desired number. you just need to simplify the 5 digit number to represent the population of data inside your sheet, and then you can use it as the row number and reference in order to return your random sample.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!