Comparisons sheet sorting

Spreadsheets
1

:wave:For some reason, every time I try to sort by a column on this report, the whole file is disrupted. the data and descriptions disappear

This category is for how to, recommended workflows, advice, and troubleshooting a Google Sheets template or solution other than the Foundation Template.

If you need help with a bank connection, missing transactions, using the Tiller Money Feeds add-on, or questions about the Foundation Template please reach out to our support team via the chat tool on the Console at https://sheets.tillerhq.com/auth/login

Did you already search the community for your question? Help us keep duplicate threads about the same question/content under control by searching before you post :slight_smile:

Click the :mag: in the upper right of this page to search.

For core product support, you can also search the Tiller Help Center at https://help.tillerhq.com, where we have hundreds of resources. What kind of customer support does Tiller offer? | Tiller Help Center

If you searched, without success, feel free to clear this content away and post your new topic.

2

Hello @Mombajuice , are you using the Tiller Foundations template? Can you be more specific about what you’re looking at and what data disappears?

Alice

3

Sorry, Using the “Comparisons “ Report .Only the headers remain, all data and descriptions disappear. Here’s a snapshot

Screenshot 2025-12-22 at 1.58.23 PM
Screenshot 2025-12-22 at 1.58.23 PM1920×1163 267 KB

4

Hello @Mombajuice ,

There is a formula in cell A5. If you sort the columns it breaks the sheet.

It’s a query function that selects columns Y, Z, AA, AB and is sorted by column AA.

=if(counta(Y2:Y)>0,query(Y:AC,"SELECT Y, Z, AA, AB WHERE Y IS NOT NULL AND AC <> ‘Hide’ ORDER BY AA LABEL Y ‘’,Z ‘’, AA ‘’, AB ‘’ ",-1),iferror(1/0))

If you expand the columns to see beyond column E, you will see what each column is. If you want to sort it differently you might want to change the Order by part of the formula to the column you want. Just change Order by AA to Order by (column Y,Z AA or AB) depending on your needs. It is case sensitive, be sure to use capital letters.

There might be a simpler report for you to use.

@Cowboy13 , would one of yours be more suitable?

1 Like
5

My Annual Comparison report doesn’t currently offer any sorting flexibility. It shows the Income then Expense Groups and their Categories, sorted alphabetically.

1 Like
6

Thank you for this @PCB , I will try what you explain here. @Cowboy13 in my opinion, sorting by Difference or Totals would be more relevant than alphabetical fwiw.

Thank you both.

7

let us know how it goes , would be helpful to share the solution in the Comparisons report thread as well.