Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Owner
  • Admin

Sort your report results with the report builder

In the report builder, you can further arrange your data with the Sort feature.

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions:

  • Owner
  • Admin

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

 

How your data will be sorted depends on its data type.

 

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.

An image showing the Sort tab

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, you grouped your data according to its Draft State. When you go to the Sort tab you won’t see Draft State as an option anymore. However, the other columns in your report will be available as sorting options. For example, you have a Due Date column. You can use that column to sort your data groups according to 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 is unable to determine which sort to honor in the consolidated column. Therefore, it sorts values as if they're in a Text/Number column.
Was this article helpful?
YesNo