Sort and Filter - New Features for Google Sheets

thanks so much for making these! very helpful, quick and to the point. what camera did you film on? looks great! love your orange chairs and rug

Re: multiple sorting criteria with filters - am I missing something when you say you can't do it? You just did it, in the video: by sorting first by order date and then category, the end result is rows sorted by category and within those categories, sorted by order date. If you did it in the opposite order, you would get them sorted by date and within the same date, by category.

Hi, is there a reason why filters don’t work on data that came from ImportRange function?

This is helpful, can you help me understand how to make filter "catergories", I don't know how to explain. In my table, I have three locations, in another cell column I have number 1,2,3. The different locations go with the numbers, so like London in line with 1, London in line with 2, Madrid in line with 1, Madrid in line with 2 2 and so on. How can I make a filter for each region so that it will be like Madrid 1, Madrid 2, Madrid 3?

That was extremely helpful, thank you for sharing.