Random Number - Generate sample from the raw data

Hey Smart-Heads!

Desired goal is to be able to extract only 20% of the rows meeting specific criteria.

As far as I know SS, does not have RANDOM formula, neither allows to write 1-2-3-4-5, double click and have the same all the way down.

Any ideas / topics (from the past?), to solve this issue?



Best Answer

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    edited 02/07/24 Answer ✓

    Hi @Romano el Polako

    I was able to achieve the 1 2 3 4 5 repeated all the way down by experimenting with an "Auto Number" column.

    This column simply counts all the rows in your sheet.

    Using this formula in a new column =MOD([Auto Number]@row - 1, 5) + 1

    Like so:

    You can modify the MOD formula if you want seemingly random numbers as well.

    Hope this helps!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!