For an overview of rollups, check out the Guide to Formula, Lookup, Count, and Rollup Fields.
A rollup field aggregates specific cells from records that are linked to another field in your table.
The following functions can be used to aggregate your rollup values.
Name | Description |
AND | Returns true if all the values are true |
ARRAYCOMPACT | Removes empty strings and null values from the array. Keeps "false" and strings that contain one or more blank characters. |
ARRAYJOIN | Join all the values into a single comma-separated string. |
ARRAYUNIQUE | Return only unique items. |
AVERAGE | Mean average of the values. |
CONCATENATE | Joins together the text values into a single text value. |
COUNT | Count only non-empty numeric values. If you want to count all records, use COUNTALL. |
COUNTA | Count the number of non-empty values. This function counts both numeric and text values. |
COUNTALL | Count the number of linked records. Choosing any column of the linked table will produce the same result. This function counts all values including blank records. |
MAX | Returns the largest of the given values. |
MIN | Returns the smallest of the given values. |
OR | Returns true if any one of the values is true. |
SUM | Sum together the values. |
XOR | Returns true if and only if odd number of values are true. |