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