📃 List & Aggregation Functions
Summarize the values pulled in through a link or lookup field — sums, averages, counts, filtering, and more.
| Function | Description | Syntax | Parameters | Example |
|---|---|---|---|---|
COUNT |
Returns the number of items in a link/lookup field. | COUNT(Field) |
Field — the link row field to count. | COUNT(FIELD('Related Orders')) |
SUM |
Returns the sum of all values in a lookup. | SUM(Lookup) |
Lookup — the looked-up values to sum. | SUM(LOOKUP('Orders', 'Amount')) |
AVERAGE |
Returns the average (mean) of all values in a lookup. | AVERAGE(Lookup) |
Lookup — the looked-up values to average. | AVERAGE(LOOKUP('Orders', 'Amount')) |
MIN |
Returns the smallest value from a lookup. | MIN(Lookup) |
Lookup — the looked-up values to compare. | MIN(LOOKUP('Orders', 'Amount')) |
MAX |
Returns the largest value from a lookup. | MAX(Lookup) |
Lookup — the looked-up values to compare. | MAX(LOOKUP('Orders', 'Amount')) |
STDDEV_POP |
Returns the population standard deviation of the values in a lookup — use when the lookup contains an entire population, not a sample. | STDDEV_POP(Lookup) |
Lookup — the looked-up values. | STDDEV_POP(LOOKUP('Orders', 'Amount')) |
STDDEV_SAMPLE |
Returns the sample standard deviation of the values in a lookup — use when the lookup is only a sample of a larger population. | STDDEV_SAMPLE(Lookup) |
Lookup — the looked-up values. | STDDEV_SAMPLE(LOOKUP('Orders', 'Amount')) |
VARIANCE_POP |
Returns the population variance of the values in a lookup — use when the lookup contains an entire population, not a sample. | VARIANCE_POP(Lookup) |
Lookup — the looked-up values. | VARIANCE_POP(LOOKUP('Orders', 'Amount')) |
VARIANCE_SAMPLE |
Returns the sample variance of the values in a lookup — use when the lookup is only a sample of a larger population. | VARIANCE_SAMPLE(Lookup) |
Lookup — the looked-up values. | VARIANCE_SAMPLE(LOOKUP('Orders', 'Amount')) |
ANY |
Returns TRUE if at least one looked-up value meets a condition. |
ANY(Lookup Condition) |
Lookup Condition — a condition built on a lookup's values. | ANY(LOOKUP('Orders', 'Status') = 'Late') |
EVERY |
Returns TRUE only if every looked-up value meets a condition. |
EVERY(Lookup Condition) |
Lookup Condition — a condition built on a lookup's values. | EVERY(LOOKUP('Orders', 'Status') = 'Paid') |
FILTER |
Narrows a lookup down to only the values that meet a given condition — typically wrapped in another aggregation. | FILTER(Lookup, Condition) |
Lookup — the values to filter.Condition — the rule to filter by. | SUM(FILTER(LOOKUP('Orders', 'Amount'), LOOKUP('Orders', 'Amount') > 10)) |
JOIN |
Combines all values from a lookup into a single text string, separated by the given separator. | JOIN(Lookup, Separator) |
Lookup — the values to combine.Separator — the text placed between each value. | JOIN(LOOKUP('Orders', 'ID'), ', ') = '101, 102, 103' |