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. |