Sorting (single and multi-column) in Google Sheets - Dashboard Guide

Dashboard Mode - Sorting (single and multi-column)

Dashboard Goal

See sales data sorted by different columns to quickly find top sales and organize data by region and product.

Sample Data

Order ID	Region	Product	Sales	Date
1001	East	Apples	150	2024-01-10
1002	West	Bananas	200	2024-01-12
1003	East	Cherries	120	2024-01-15
1004	North	Apples	180	2024-01-20
1005	South	Bananas	160	2024-01-22
1006	West	Cherries	140	2024-01-25
1007	North	Bananas	210	2024-01-28

Dashboard Components

• Sorted by Sales (Single Column Sort)
  =SORT(A2:E8, 4, FALSE)
  Shows all orders sorted by Sales from highest to lowest.
• Sorted by Region then Product (Multi-Column Sort)
  =SORT(A2:E8, 2, TRUE, 3, TRUE)
  Shows all orders sorted alphabetically by Region, then by Product within each Region.

Dashboard Layout

+----------------------------+------------------------------+
| Sorted by Sales            | Sorted by Region then Product |
| (Single Column Sort)       | (Multi-Column Sort)           |
| [SORT formula result]      | [SORT formula result]         |
+----------------------------+------------------------------+

Interactivity

Modify the column numbers or TRUE/FALSE in the SORT formulas to sort by different criteria. Combine with FILTER function for dynamic filtering by region or other conditions.

Self Check

In the single-column sort by Sales (descending), the first row shows the highest sales of 210 (Order ID 1007). In the multi-column sort, orders from 'East' appear first, followed by 'North', with products sorted alphabetically within each region.

Key Result

Dashboard shows sales data sorted by sales amount and by region then product for easy comparison.