Sort your report results with the report builder

The data type determines how the system sorts your data.

To sort data in reports

1. In the menu bar, select Sort. 
2. Identify how you want to sort your data. 

3. Optional: To add another sorting rule, select Sort by another column.
    

   You can have only three sorting rules.

    

4. Select OK.

Brandfolder Image

Sort vs. Group

Fields you used in the Group tab can’t be used in the Sort tab. Instead, you can specify the order in which you want your groups to appear.

For example, if you group your data by Draft State, the Sort tab no longer lists Draft State as an option. The other report columns remain available for sorting. For instance, you can use the Due Date column to sort data groups by their deadlines.

Learn more about grouping data in the report builder.

Sort dropdown lists

Expect these app behaviors when you sort dropdown columns:

• Dropdown-column sorting behaves differently in reports and sheets. When you sort a dropdown column in a report, items are sorted in ascending or descending order. In sheets, when you sort dropdown columns, items are sorted based on how the dropdown values are arranged in the column properties of that source sheet.
• A report can pull from multiple sheets. However, it consolidates only columns with the same name and column type. If the dropdown list columns have different values across sheets (for example, a, b, c, d in one sheet and 1, 2, 3, 4 in another), the report cannot determine which sort to apply to the consolidated column. Therefore, it sorts values as if they're in a Text/Number column.