SHUFFLE
The SHUFFLE function takes the items in any given list and re-orders them randomly.
This function takes any list as input. It outputs another list with all the same items as the first list in a random order.
Declaration
Parameters
list (required, type: list)
A list containing any number of items. These items can be of any type and do not need to be the same type as each other.
Return Values
shuffled_list (type: list)
The resulting shuffled list with all the items randomly re-ordered.
Examples
The following example takes a list of numbers one through six and puts them in a random order. Note that running the same formula three separate times results in three slightly different outputs. Each time the SHUFFLE function is called upon, it randomizes anew:
The above example, list was hardcoded, but that doesn't need to be the case. For the last example, assume the formula has access to the following list:
Last updated
Was this helpful?