I’m new to Tiller, and I was finding it hard to see which items I had overridden for my budget on my categories sheet. I’ve got a bunch of categories and do have some budget items that arrive during specific months.
I’m really liking Tiller, because it is a sheet, I can simply update to solve my issues.
To make my changes visible, I just added a simple Conditional Format rule that checks if the cell is a function, and applies a different cell color if it is:
I see the show & tell so far has been showing some sophisticated solutions. Are there other simple modifications people have made? (Is this the place to show them?) I would love to see more…
Very nice solution, @mre! Thanks for adding to the community. I’ll have to keep that conditional formatting in my back pocket for when I’m modifying or troubleshooting my sheets.
So cool! I love reading about the sophisticated solutions - I don’t have enough spreadsheet smarts to implement, but I love reading about them. BUT this! This I can do. Thanks for the idea!
My simple (similar) modification is that I use conditional formatting on the Transactions sheet Category column to highlight any transactions that are not categorized. It’s a minor change, but makes it easier to see if I skipped categorizing something.
I’ll have to keep that conditional formatting in my back pocket for when I’m modifying or troubleshooting my sheets.