How does Tiller populate the Accounts sheet?

While working on another google sheets project, I realized I needed to do something similar to what tiller does when populating the Accounts sheet using data from the Balance History sheet - in particular how an account’s Last Update date and Last Balance are extracted.

I could not find any formulas in the Accounts sheet to give a clue on how this is done. I assume this is done with code in the Tiller Add-on. Is there any way I can view this code?

I did come up with formulas using ArrayFormula() but my sheet has a large number of rows and this is becoming very slow.

There are hidden columns in the sheet you can look at. I created a history tracker, Balance History Tracker which I needed to do what you’re looking for. You can take a look at my formula to see if it helps.

1 Like