Airtable's grouped records feature allows you to show your records grouped together based on one (or more) fields of your choosing.
You can also use grouped records to generate reports—see this support article for more information.
Getting started with grouped records
Dragging between groups to reassign values
Grouped records and the summary bar
Getting started with grouped records
To group your records, open up a grid view and click on the "Group" button located between the filter and sort buttons.
Select the field by which you'd like to group your records from the dropdown menu. Note that you cannot group by an attachment field.
You can also group your records by multiple fields by clicking the "Pick another field to group by" button.
You can also change the sort order of the groups by clicking on the sort order buttons after each grouped-by field's "Group by {Field name} from."
Groups also work with filters.
To remove a group, click on the X button to the right of the specified grouped-by field.
Dragging between groups to reassign values
You can change the values on a record in a group by clicking and dragging the record to a different group using the drag handle on the left side of the record. For example, you could drag a task assigned to one person to another person's group, and that task would automatically be re-assigned to the new person.
Note that you cannot add new records to a grouping that is based on a computed field type (like a lookup, rollup, or formula field).
Grouped records and the summary bar
There is a summary bar at the top of every group, which can summarize the cell values in numerical fields by each group. These summary bars let you see the subtotals of each grouping. Every grouping will also have a count of the number of records in each grouping.
Much like the summary bar for the whole table, the summary bar for each group can provide different summary functions.
