Having an issue loading the sheet:
The add-on could not add the requested sheet or its dependencies.
The process failed with message: “Cannot call method “copyTo” of undefined.”
Resolve the issue and then try again.
Any help appreciated
@randy I ran into this issue as well when trying to install, I think the TCS installer is broken for this one.
I’m having the same issue where I’m not able to add the transaction tracker sheet.
Typically, it gets added despite the error message - scroll all the way to the right of your sheet tabs to check.
I checked and I still don’t have it.
I used to have the transaction tracker and for some reason it stopped working. I went through the process to restore it and it hung. When I refreshed the sheet, the transaction tracker was removed so I attempted to install it and that’s when I got this error. This may or not be related to my attempt to restore it previously, but at the moment, I don’t have the TT tab.
It did not add the sheet to my document.
Sorry wrong reply. I meant to reply to Mark
Also having this issue. It stopped working and was being pretty weird. So I tried to just restore the solution and I got the same error. I cannot get the sheet to show up at all again. When I try to re-add the spreadsheet it just hangs. I let attempt at adding the sheet for roughly 8 hours and it was still stuck trying to add it, spinning in circles.
I just tried reloading and it works now, thank you
It works for me now. I’m able to add the transaction tracker back to my sheet. Thank you!
For those that did add the Merchant Name column to the Transactions sheet, is it possible to have both filters (Description and Merchant Name) in the Transaction Tracker? I would love to be able to filter by Merchant Name for a certain time period and still view the Description details. Thanks for this amazing report and consideration!
Hello all,
First post on these boards, but not my first interaction, since I’ve read many, many of the great discussions since moving over to Tiller from a brokerage company’s Yodlee-feed based, captive expense tracking system. Everyone here is so very knowledgeable and the underlying product is so great. When I started with Tiller one thing I thought was lacking was a transaction report – something short of messing with sorting or categorizing the sacred transaction sheet – and lo and behold I found “Transaction Tracker”. Yay!
Here’s my question:
How can I change the order of the results columns?
For my eye and use, “Amount” is way too far to the right in the results area and should be closer to “Description”. I was able to work on the formula in A12 to get “Amount” moved to the “C” column, but at the cost of everything else breaking as I tried to shift “Group” over to “F” (or shift “Group” anywhere for that matter).
There must be much more going on in the formula in A12 than I understand, yet it seems like this, custom column order, would be a commonly desired modification to the sheet to get results of the query just as the user desires.
What I’m trying to achieve is a column order from A12 to I12 of…
Date
Description
Amount
Tags
Notes
Group
Category
Institution
Account
And I’m not suggesting that this modification would be made more than once, meaning, no need for drop-down boxes, or other tools. I’m just looking for: what would be the A12 formula for the column order above?
Any help would be appreciated, and again thanks for such a great financial tool.
Hello, thanks to all the relevant information posted on this thread. I am a heavy user of Transaction Tracker for Google sheets as it allows to create detailed spending reports with categories and sub-categories. While reviewing spending for 2024 it occurred to me that TT is refusing to tally up the numbers for 2 of my categories. It only happens with these 2 categories. As soon as I type the category in the category field, I see this #VALUE! in the column where date usually is. If I bring the mouse to the box it shows me this error:
Error Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "s “” at line 1, column 78. Was expecting one of: “group” … “pivot” … “order” … “skipping” … “limit” … “offset” … “label” … “format” … “options” … “and” … “or” …
I know there is no problem with these categories as I have a Google sheet called monthly spending/categories in my foundation sheet and the numbers are reported correctly in that sheet. I am puzzled as why TT is acting the way it does. I deleted the TT and restored it but the problem persists. Any help is appreciated.
@DoubleEntry In quickly looking at it, it appears to need some diligence but can be figured out. Hidden columns S-V are also a good reference.
For example Amount is col5, so in the A12 formula you could modify as such at the start:
=QUERY({INDIRECT(V14),INDIRECT(V15),INDIRECT (V19),INDIRECT(V18),INDIRECT(V20),INDIRECT(V21),INDIRECT(V19), indirect(V22), indirect(V24), indirect(V26)}, "select Col1,Col2,Col5,Col3,Col4,Col10,Col9, Col6, Col8 where....
And in that case the formula for Total Amount (G12) will have to be modified to =sum(C12:C) from =sum(G12:G)
I suggest making a copy of the Transaction Tracker and then fidgeting one field at a time in the copy making sure the figures still line up. From that query in A12 the checks against the filters are also hard coded so one has to be careful not to move those filters entry cells and/or if those are modified then the query has to be modified accordingly
@flojony are you having to type categories in? They should all be dropdown menus. You mean in the filters?
Thank you so much. I’ll give it a try.
There’s something happening in the A12 formula that drives the column headers and determines their sort across the results. With your fix I was able to move ‘Amount’ but the other column are intransigent. But that’s okay. I ended up hiding the whole of row 12 and hard coded in the column names in 11. Also of note, when I move the ‘Amount’ column that required some adjustments to array formula in R13, essentially changing G column references to my new “Amount” column of C. Also, references to the newly organized columns have to conform in the R13 array if one wants that part of the sheet to operate. Thanks again!
@flojony what are names of the two problematic categories?
I’m happy to help! 
They are self-created categories I use to track my children spending (as the each have credit cards that are under my account). But I have other categories such as an Amazon category that do not give me similar problem in Transaction Tracker.
