The Transactions sheet in the Foundation Template defaults to reverse chronological order. Loading all new transactions up top. All good. That said, I chose to sort it in chronological order. Why? B/c I have Zapier set up to add a new row in a different sheet every time a new row is created in the …

Hi @jack , I don’t think the auto sorting by reverse chronological order can be disabled. But, you could create a new sheet that automatically sorts transactions in chronological order and have Zapier run off of that sheet. In a new sheet, enter this in A1: =QUERY(Transactions!A:Z,"SELECT * ORDER…

@jack we just released this feature to help with this! [image] Tiller Money Feeds Releases: Auto Sort override and faster update sheets options News & Announcements Today we pushed an update to the Tiller Money Feeds add-on that includes the following new features. Auto …

I’d like to use the method @jono suggested here years ago, the query only shows one row of data…just the headers?

Hi @robertgranholm , Scroll down to the bottom of your new sheet. I wonder if your transactions are showing at the bottom because you have blank lines in at the bottom of your transaction sheet. They might show up at the top with that QUERY. You might need to add a validation to ignore empty rows,…

I turned on the auto sort override, but my manual transactions are still sorting to the top. Is there a way to fix this?

Thanks for the response Heather, but this is what I’ve already done. However, manual transactions still sort to the top. Does the Auto Sort Override not work for transactions that are entered manually? I could just type it into the bottom, but I want it to also update the balance on that manual a…

Hi @miyekot I think you’re right the manual transaction insert does not do a sort of the Transactions sheet and just adds them to the top of the Transactions sheet. You’ll want to manually sort by the date column for now and you can add a Feature Request to have it sort for you.

Transactions in Chronological Order

Spreadsheets Google Sheets

heather May 19, 2020, 6:02pm 3

@jack we just released this feature to help with this!

Topic		Replies	Views
Sorting within the Transactions sheet Ask Anything	1	130	May 20, 2025
Transactions Staying at Bottom of Sheet - Troubleshooting Help Needed Google Sheets	11	722	January 4, 2024
Recent Tranactions added at random places in Transactions sheet Google Sheets	3	243	January 23, 2024
Automatic Transaction Sorting - Excel Microsoft Excel excel , troubleshooting	1	834	March 10, 2022
New transactions imported the bottom of transactions tab Google Sheets troubleshooting	4	367	May 10, 2023

Transactions in Chronological Order

Related topics