# Share a Tiller hack that took you way too long to figure out. Help someone else skip the struggle! **URL:** \ **Category:** Ask Anything\ **Created:** [June 8, 2026, 5:47pm UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799 "2026-06-08T17:47:59Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Clint.C](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/clint.c/32/17291_2.png) [@Clint.C](https://community.tiller.com/u/Clint.C)\ **Post date:** [June 8, 2026, 5:47pm UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799/1 "2026-06-08T17:47:59Z")
Let’s discuss! “Share a Tiller hack that took you way too long to figure out. Help someone else skip the struggle!” ---
**Author:** ![jpfieber](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jpfieber/32/4791_2.png) [@jpfieber](https://community.tiller.com/u/jpfieber)\ **Post date:** [June 8, 2026, 6:39pm UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799/2 "2026-06-08T18:39:10Z")
As I was trying to think of things, and was clicking through my sheets looking for ideas, it occured to me that on my Transactions sheet, instead of “Hiding” the columns that I don’t normally need to see, and then later trying to remember which was which when unhiding them, I could instead rearrange them so they are all together on the right side of the sheet, and then group them (select all the columns, right-click and choose “View more column actions…” and then “Group columns…”) so they collapse under a ‘+’. Now I don’t have to hide and unhide different columns on my Transactions sheet, I just expand and collapse the group to see the stuff I don’t normally care to see. What’s sad thing is I’ve been handing my “Helper data” columns like this on my templates for years, but it took me until today to realize it was useful on Transactions as well! That took waaayy to long! ---
**Author:** ![casilverthorn.96](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/casilverthorn.96/32/24067_2.png) [@casilverthorn.96](https://community.tiller.com/u/casilverthorn.96)\ **Post date:** [June 8, 2026, 6:51pm UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799/3 "2026-06-08T18:51:15Z")
That is fantastic! I need to remember that. I use groups and rearrange personal stuff all the time, it didn’t occur to me to try it in tiller. Yay for dynamic ranges that allow this. Personalization is used a lot in tiller for me. As for a hack, I don’t think I have been able to crack that one yet. lol. I look forward to other responses so I can learn more though. ---
**Author:** ![ctlee](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ctlee/32/7831_2.png) [@ctlee](https://community.tiller.com/u/ctlee)\ **Post date:** [June 13, 2026, 11:34pm UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799/4 "2026-06-13T23:34:39Z")
Similar to to the grouping, as the tiller setup evolves over time, i try to keep a list of the processes and adjustments made from default so it’s easier to replicate when going from default. especially with all the new changes, this makes it easier to see if what’s breaking the sheet are the changes, or just the modifications that others don’t have. ---
**Author:** ![deniseskidmore](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/deniseskidmore/32/25128_2.png) [@deniseskidmore](https://community.tiller.com/u/deniseskidmore)\ **Post date:** [June 14, 2026, 4:54am UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799/5 "2026-06-14T04:54:40Z")
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](https://community.tiller.com/t/taking-advantage-of-custom-arrays-in-google-sheets/10586#custom-query-ranges-9): > > 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](https://support.google.com/docs/answer/6208276?hl=en) 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](https://support.google.com/docs/answer/6208276?hl=en) shows some pretty simple examples. Fundamentals In essence, you … > [@Building Type-Group-Category Hierarchies into Your Dashboards](https://community.tiller.com/t/building-type-group-category-hierarchies-into-your-dashboards/18696): > > 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. 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](https://support.google.com/docs/answer/3093343?hl=en)** > > Runs a Google Visualization API Query Language query across data. Sample Usage QUERY(A2:E6,"select avg(A) pivot B") QUERY(A2:E6,F2,FALSE) Syntax QUERY(data, query, \[headers\]) data > **[ARRAYFORMULA - Google Docs Editors Help](https://support.google.com/docs/answer/3093275?hl=en)** > > Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays. Sample Usage ARRAYFORMULA(SUM(IF(A1:A10\>5, A1:A10, 0 > **[Tiller Core Data Column Reference](https://docs.google.com/spreadsheets/u/0/d/116LhgKnGtX08ErG8RyfYBViRXdwWh671fuz9ZK6BSFA/htmlview)** > 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”. ---
**Author:** ![deniseskidmore](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/deniseskidmore/32/25128_2.png) [@deniseskidmore](https://community.tiller.com/u/deniseskidmore)\ **Post date:** [June 15, 2026, 5:25am UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799/6 "2026-06-15T05:25:05Z")
I just figured out how to fake a Join with ARRAYFORMULA and XLOOKUP =QUERY({Transactions!G2:G,Transactions!B2:B, Transactions!D2:D, Transactions!F2:F, ARRAYFORMULA(iferror(XLOOKUP(Transactions!G2:G, A$2:A$3, D$2:D$3)))},“Select \*”) ---
**Author:** ![jdackson](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jdackson/32/2049_2.png) [@jdackson](https://community.tiller.com/u/jdackson)\ **Post date:** [September 5, 2026, 11:14pm UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799/7 "2026-09-05T23:14:10Z")
Does anyone have a hack to get the actual transaction date? When working with family, to identify an unfamilar transaction it would be helpful to know when the transaction actually occurred. Conversations currently go something like, “Hey, do you know what the $7.49 transaction with Target was? What day? Well, I don’t know; it was 2 or 3 days before [insert date].” ---
**Author:** ![casilverthorn.96](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/casilverthorn.96/32/24067_2.png) [@casilverthorn.96](https://community.tiller.com/u/casilverthorn.96)\ **Post date:** [September 7, 2026, 8:37pm UTC](https://community.tiller.com/t/share-a-tiller-hack-that-took-you-way-too-long-to-figure-out-help-someone-else-skip-the-struggle/34799/8 "2026-09-07T20:37:54Z")
As far as I know it is not available due to how the transactions come in from the aggregators. I know this has come up before as a topic of conversation.