SLOTS
The SLOTS function takes a list of items and groups them into slots.
Last updated
The SLOTS function takes a list of items and groups them into slots.
Last updated
It also accepts a group of lists, returning, in this case, a group with slots in each of its entries.
SLOTS(items, table, [multiple])
Table syntax
If:
items = [p1, p2, p3, p4, p5]
And table is:
SLOTS(items, table) will return:
SLOTS(items, table, true) will return:
If:
items = [p1, p2, p5, p3, p4, p5]
and table is:
SLOTS(items, table, true) will return:
Note p5 has a higher priority because it appears twice in the list.
If:
items = {group1:[p1, p2, p3, p4], group2:[p5, p6, p7, p8]}
and table is:
SLOTS(items, table, true) will return:
Argument name
Description
items
Required
List of items, or group of lists. The list can contain duplicated items, in whose case they will weigh more and will be prioritized in the slots.
table
Required
Table with the association between each item and its group. An item can be also associated with multiple slots.
multiple
Optional
If true, each slot will accept more than a single item. It is false by default.
Column name
Description
item
Required
Item identifier.
slot
Required
Slot identifier.
