My budget tracking solution still lies in Google Sheets because it contains so many formulas that break when converting to .ods that I've been putting it off for about a year now because it will be a lot of work to recreate properly in LibreOffice Calc. So I can't share a full solution with you.
I can help you consolidate your categories into a drop-down though! I recommend creating a new sheet within your workbook that you can hide/unhide as needed to edit your behind-the-scenes information like categories.
Step 1 is to add your list of categories somewhere in the sheet like this:
Step 2 is to define the range of categories so that it's easier to use in formulas later. Highlight all the categories, then select Sheet > Named Ranges and Expressions > Define, and give it a name (I use "categories"):
Step 3 is to set up your main sheet to use the new list. Highlight the cell where you want the drop-down list to be, then select Data > Validity > Allow = Cell range > Source = "categories" (or whatever you named your list) > OK:
My budget tracking solution still lies in Google Sheets because it contains so many formulas that break when converting to .ods that I've been putting it off for about a year now because it will be a lot of work to recreate properly in LibreOffice Calc. So I can't share a full solution with you.
I can help you consolidate your categories into a drop-down though! I recommend creating a new sheet within your workbook that you can hide/unhide as needed to edit your behind-the-scenes information like categories. Step 1 is to add your list of categories somewhere in the sheet like this:
Step 2 is to define the range of categories so that it's easier to use in formulas later. Highlight all the categories, then select Sheet > Named Ranges and Expressions > Define, and give it a name (I use "categories"):
Step 3 is to set up your main sheet to use the new list. Highlight the cell where you want the drop-down list to be, then select Data > Validity > Allow = Cell range > Source = "categories" (or whatever you named your list) > OK:
You should end up with something like this: