Share a Tiller hack that took you way too long to figure out. Help someone else skip the struggle!

[deniseskidmore]

I’m new at Tiller but a long term spreadsheet nerd…

Reference guides I’ve been collecting:

Taking Advantage of Custom Arrays in Google Sheets

One feature in Google Sheets that I find incredibly helpful that isn’t well understood is the ability to build custom arrays/ranges within formulas. The Google Sheets documentation has a brief & unassuming callout to this capability that does not really acknowledge its power or potential. Let’s dig into how this capability works and how to use it to super charge your spreadsheets… Building Custom Ranges The documentation above shows some pretty simple examples. Fundamentals In essence, you …

Building Type-Group-Category Hierarchies into Your Dashboards

Overview Many of Tiller’s most popular dashboards include organize categories into a type-group-category hierarchy for user-friendly browsing. You might recognize this hierarchy from templates like the Monthly Budget, the Savings Budget, and the Yearly Budget. [image] If you have ever tried to build this type of hierarchy into your own templates, you know that the implementation is pretty fussy. Inspired by some encouragement by @jpfieber, I refactored the formulas we use to implement this…

QUERY function - Google Docs Editors Help

ARRAYFORMULA - Google Docs Editors Help

Tiller Core Data Column Reference

How can I Unpivot a Query?

ArrayFormula is very powerful, but not all functions work inside of it. One thing you can do is replace and/or with math. 0 is false, > 0 is true, so you can use A * B for “and” or A+ B for “or”.