These docs are for v1.0. Click to read the latest docs for v1.2.

SHUFFLE

Randomly shuffles the values in the given array.

Syntax

=SHUFFLE(array)

Arguments

ArgumentTypeDescription
arrayArrayThe array of values to shuffle

Examples

=SHUFFLE([1, 2, 3, 4, 5])[4, 5, 2, 1, 3]