How is the order of unique values in a subtable returned in a UNIQUE() call?
Is there a way/function to sort them?
Hi,
The UNIQUE() formula displays values according to the current order shown in the referenced subtable. If you want to sort the values in a specific order, you can use the filtering and sorting options in subtables to arrange the values as desired. Once you have sorted the subtable, triggering formula recalculation will reflect the new order. Alternatively, simply double-clicking any field or making any data edits will trigger the system to automatically recalculate the formula.