TOLIST (MULTI-FIELD)
Converts the given fields to a List where each field value is an element in the list.
SyntaxTOLIST({{myfield1}}, {{myfield2}}, ..., {{myfieldN}}, 'optionalFilterFormula')
Example
TOLIST({{myfield1}}, {{myfield2}}, ..., {{myfield3}})
TOLIST({{myfield1}}, {{myfield2}}, ..., {{myfield3}},'STARTSWITH({{this}}, "B")')Notes
Second optional parameter applies a filter formula to the List elements gathered, leaving only elements that pass the condition.
Use {{this}} to refer to the element value in formula.