Rollup field reference
- 24 Jul 2023
- 1 Minute to read
- Print
- DarkLight
Rollup field reference
- Updated on 24 Jul 2023
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
A rollup field aggregates specific cells from records that are linked to another field in your table. For an overview of rollups, check out the Rollup field overview.
Introduction
Plan availability | All plan types |
Platform(s) | Web/Browser, Mac app, and Windows app |
Try it in Airtable |
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 numbers. |
MIN | Returns the smallest of the given numbers. |
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. |
Was this article helpful?