I want to sort a table by two levels, column A and column B. I can only see that you can sort by one column. Am I missing anything or are there any tricks?

As the error says, you have data in the rest of the column, so the arrayformula can’t fill the rest of the column. Delete the data in the column below the row that contains the formula.

Can you sort by two columns?

Ask for Help

ThinhDinh April 23, 2021, 11:57pm 10

You can read more about it here.

Hope it helps.

1 Like

Topic		Replies	Views
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help	125	13756	September 9, 2022
Combining 2 identical columns into one Ask for Help	8	48	February 21, 2025
How to If-then-else—> array? Report a Bug	9	838	February 7, 2024
Range returning more than one value per row on arrayformula Ask for Help	8	497	October 10, 2019
Push formatted data from Glide App to Google Sheets Ask for Help	3	336	November 21, 2021

Can you sort by two columns?

Related topics