Question about Spending trends 2.0 uncategorized count formula

Spreadsheets Google Sheets
1

I created a new spreadsheet today just to make sure, but the Spending trends 2.0 sheet does not use a dynamic reference in cell C17 to count uncategorized transactions.

This is the formula
“=COUNTIFS(
Transactions!D2:D;“=”;
Transactions!B2:B;“<>”;
Transactions!B2:B;“>=”&IF(B6=“”;DATE(1900;1;1);B6);
Transactions!B2:B;“<=”&IF(B9=“”;DATE(9999;12;31);B9)
)”

Shouldn’t it use indirect as the other sheets do? I had rows that did not add correctly and the total was skewed.

2

@heather , @randy I”m tagging you because I didn’t know what category to put this topic in.

3

@PCB Did you get an answer to your question? If not, the category to have placed the question in is the Tiller Beta.

4

I don’t know cause it’s now in the template when you create a new sheet.

Téléchargez Outlook pour iOS

5

@PCB good call out here. Unintentional, just an artifact of it being a quickly built out template but then not coming back to it soon enough to do a thorough cleanup.

6

Where do you get the Spending Trends 2.0 sheet that is screenshotted on the Tiller home page?

7

Hey! It should be a new foundation template when you create a new spreadsheet.

8

So I have to create an entirely new spreadsheet and re-import all transactions to use it? Or can I just copy and paste the transactions sheet?

9

No. Create a new blank template. Then right click on the spending trend sheet in that template and select copy to an existing sheet (the one you’re using now)

10

Thanks, I went to File > New > Spreadsheet, then Extensions > Tiller Money Feeds > Templates, added Spending Trend sheet > and it looks just like the old Spending Trend sheet. (There’s no Simple Transaction lookup, pie chart of expense categories, etc.)

11

Sorry, maybe I wasn’t clear enough. Create an entire new spreadsheet from the console. It will have the new foundation template in it.

Open the new spreadsheet you created and copy the new spending trends to your actual workbook.

12

Thank you, that worked! Hopefully people who are toddling along with the old Spending Trends are able to upgrade as well, as I saw no notice of this anywhere and just happened to see the new Tiller home page.

13

You’re welcome. Let @heather know, they might be able to update it.

14

@jules you can get the Spending Trends 2.0 via the steps documented here: Using the Spending Trends Sheet | Tiller Help Center

It’s a manual copy in process for now. We’ll get the add-on updated with it at some point, but I don’t have a timeline for that.