Here’s how sorting works on Numbers, Apple’s spreadsheet program:
- Start with a simple table, where everything is displayed in the original order:
- Sort a part of the table. In this case, I sorted the Amount in descending order:
- Sort another part of the table. In this case, I sorted the Category in ascending order:
Notice that, where the Category values are equal, the Amount values remain sorted in descending order.
In table view we can easily sort by tapping on the header at the top (if the headers are displayed). However, when we tap on another header, AppSheet seems to forget what it has just done and sorts the table as though a sort had not preceded it.
If it’s not too difficult (or too expensive in terms of computing power), I think it would be great if AppSheet’s table sort could remember preceding sorts in the manner I’ve described here.