Randomly Select Questions from a Bank in Google Forms

[@clementobieromah1908]

How do I handle a multichoice question back?

[@seanr.sullivan6336]

@5:05 If you're concerned about the questions changing after you start, you could use Copy, then Paste Values Only to make them permanent.

[@edmccann2915]

Great video. My test bank has separate columns for question, answer 1, answer 2, 3, 4, and correct answer. How can I pull the random questions along with their corresponding answer choices and answer?

[@GalaxyTab-u5k]

you can use the match function

[@aimeegoldberg9578]

@@GalaxyTab-u5k How? Can you please paste a formula that would work?

[@jessicabaum9370]

@@GalaxyTab-u5k How do you do that?

[@jessicabaum9370]

@@GalaxyTab-u5k How do you do that?

[@smuzzamilbasha-tp1wt]

How to do this can you please explain

[@Ram_Mandir]

=ARRAY_CONSTRAIN( SORT( FILTER(A2:A, A2:A" "), RANDARRAY( COUNTA(A2:A), 1), TRUE), 5, 1) NOT WORKING

[@meridithberghauer1455]

You have a space between your " ", delete the space and it works just fine.

[@Ram_Mandir]

@@meridithberghauer1455 ya after doing so much I got that. Thnx by the way

[@marcorodriguez7997]

I had to change commas (,) to (;) in orden for it to work