A rollup field performs calculations or formulas on specific cells from records that are linked to another field in your table. Sound complicated? It’s not! Watch this video guide and get started in seconds. Spreadsheet users can think of the rollup field as a way of creating more sophisticated pivot tables.
A rollup field lets you aggregate values from linked records. For example, consider a database that helps the owner of a furniture store keep track of orders and pieces of furniture. A single order could contain several pieces of furniture. This could be represented by linking several furniture records to each order. A rollup would then allow you to calculate the total price of the furniture records in each order.
You configure a rollup by first selecting the field that links to the records you're interested in aggregating.
You then select the cell on those records that you'd like to aggregate.
The last step is to select a way to aggregate the cell values from the linked records. Average, sum, min and max are a few examples of aggregation functions you can use on a rollup.
When you start editing the aggregation input, you will see suggestions for potential rollup functions with a brief description of each function.
For a complete reference of rollup aggregation functions, please see our rollup field reference.
Note that a rollup field will roll up data from all records in the target linked table, regardless of whether or not those records have been filtered in some way. If you only want to rollup certain linked records in each cell, you will need to use IF formulas to make conditional rollups.