User Request: Detailed Category Tracker

Works great. Thanks!

1 Like

I thought you had it perfected, and then, there you go… making it even better! Updated!

1 Like

I made a minor correction on the Transaction Tracker to the Total for Category/Group label in E8 and G8. The header wasn’t changing with the Category/Group dropdown, and the sum wasn’t taking the column drift into account when looking for the Amount column.

If you want to simply copy/paste formulas, you can replace them with the following. Otherwise, you can replace your entire Transaction Tracker sheet with the template.
E8

="Total for "&G3

G8

=IF(G3="Category",sum(F10:F),IF(G3="Group",sum(G10:G),""))

1 Like

I’m new to Tiller and really want it to be great. So far I’m finding out that it’s just as much a lesson in spreadsheets as financial tracking. That’s not so great. Someone makes a template and constantly tweaks and updates it and the only way to find it is by spending time digging through stuff when I should be working on my finances. Isn’t there a “latest and greatest” page where everyone ‘s cool templates are found?