Count of transactions yet to be categorized

[shankarimohan7]

This is a small incremental improvement that I though others may also like

Just a simple formula that you can drop anywhere that will let you know how many transactions exist that have not yet been categorized:

=if(countif(Transactions!D:D,"") > 0, concat(countif(Transactions!D:D,""), " Uncategorized transactions"), "")

I would have liked to put this somewhere on the Transactions sheet but did not find a convenient location without disturbing the existing functionality. So I have this at the top of the Balances Sheet - but you could put it on any sheet that you visit frequently.

[jpfieber]

I think the “Savings Budget” template includes a counter like this, but you’re right, it might be nice to include in other places, especially if you don’t use “Savings Budget”! It should be mentioned that you might have to change the ‘D’ to a different letter if your “Category” column isn’t ‘D’ (they can be moved around).
Also, when pasting formulas in the forum, be careful for “Smart Quotes”, which are different from normal double-quotes and usually cause problems in formulas. Here’s your formula with normal double-quotes:
=if(countif(Transactions!D:D,"") > 0, concat(countif(Transactions!D:D,""), " Uncategorized transactions"), "")

[susandennis]

OMG! I have wanted this for so long! I tried to noodle it myself last year and never got what I wanted exactly which is this. My Balances tab is my go to and now it’s complete.

Thank you so so so much!

[susandennis]

Thanks! works perfectly.

[randy]

Thanks for sharing, @shankarimohan7.

[diogo6]

Nice, glad you also find something like this useful… I use a similar notion on my Insights Sheet:

=“→ You have “&countif(Transactions!E:E,””)+countif(Transactions!E:E,FALSE)&" unreviewed transaction(s), and “&countif(Transactions!D:D,”“)&” uncategorized one(s)."

which counts these: