Random numbers / Random form questions.

I'm looking for a way to generate questions via a form. Say we have 100 questions on a grid split into 10 sections. In an ideal world I'd like to pick 3 random questions from each section and then have that listed on a form.

One way could be to have a random generator of sorts and have it randomly assign a number to each question. and then filter questions based on this.

Is this at all possible to do?


  • David Joyeuse
    David Joyeuse ✭✭✭✭✭

    Hi @Graham Ledger

    That's interesting as I'm looking to do the same kind of thing on Smartsheet right now for one of my beloved colleague.

    But there's many problems here to workaround. And if you really want to have a randomized type of forms and such, it will probably require to go through the use of some API.

    An easiest way, that may be suitable, would be to have a sheet with as many columns as you'd like so that would be 100 using your example.

    Then create as many forms as you'd like displaying questions or removing them from the form. Still using your example, you would then pick 3 questions from each section in the form. Which would make it a 30 questions forms.

    You would have then to pick a different form each time.

    It's not entirely randomized, but so far that's the best answer I do have on the subject.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!