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.

You can create a template column that joins two columns together. Then sort by that template column. Just do some thorough testing to make sure it’s sorting correctly if your first column has varying lengths. For something like this, I like to separate both values in the template with a ‘-’ or ‘|…

I tried this method and it works but I ended up having to zero fill my numbers as it was sorting incorrectly. For example 100 would be sorted before 20 and 3. I used the following function in Google Sheets =ARRAYFORMULA(if(ISBLANK(D2),"",TEXT(D2,“0000000000”))). The challenge is that it the formula …

Try using D2:D instead of D2, I believe it will work. However if you do not really need that data inside the Sheet, you can try Jeff’s method, which would work inside Glide.

I have tried D2:D but the issue is that i get a #REF! Error. [Screen Shot 2021-04-23 at 10.24.39 AM]

That is perfect, I thought you had to copy the array formula down. I didn’t realize that you only have the formula at the top and the values automatically copy all the way down. This is AMAZING! Thank you so much!

One other thing I found out that I am others know but wanted to contribute. The CONCATENATE formula does not work the way I expected with the ARRAYFORMULA. Instead I used the CONCAT command and that did the trick. The only limitation is that CONCAT only combines two inputs. =ARRAYFORMULA(CONCAT(B2:…

You can read more about it here. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work wit…

I would use a template column inside Glide for this, again, if you don’t need to see that formula in Sheets.

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.

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

Can you sort by two columns?

Related topics