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.