Has anyone found a way to have Sub Categories on the Categories sheet of Google Sheets and then have those populate to the Transactions sheet when you select a given category? I know some people use Groups and Tags, but I have a use case whereby having “Sub Categories” would be ideal. TY

Sub Cats are not built into the software, so to get that to work you’d have to rewrite a lot of stuff I think. I asked about this a little while back and that’s the answer I essentially got. Groups - Categories and Tags is the current framework for organization.

Definitely a much requested enhancement. But agreed this would require a bunch of rewiring

TY for the link. I will check it out.

I tried to add Sub Categories awhile ago and things got pretty messy. I have been using a different approach to get 3 levels of Category hierarchy. It required some formula re-writing and new sheets, but I got it working for my needs. You might consider this concept as well as a Sub Category alter…

Interesting. I need to think this through to see if it will work. TY for the idea!

It would be really helpful for Tiller to add this Subcategory feature. Hopefully we can get a movement started to get this in the future.

You can vote up or add a feature request @alkrongold such as this one

SUB CATEGORIES tied to a Related Category

Spreadsheets Google Sheets

brettanicus October 22, 2024, 8:10pm 4

I’m not sure about your use case, but check out the Category Schedule template.

Topic		Replies	Views
Creating Group and Sub group in Auto Cat? Google Sheets how-to	3	1031	December 23, 2020
Data Validated Sub-Categories Google Sheets how-to , budgeting	4	3055	October 26, 2019
Creating Budgets for Groups? Google Sheets how-to , budgeting	15	1791	December 19, 2023
Parent Category Budget Amounts Like Quicken Ask Anything how-to , budgeting	5	1021	April 12, 2021
Can we have multiple categories rolling into a single category-Subcategories? Ask Anything	4	869	March 5, 2023

SUB CATEGORIES tied to a Related Category

Related topics