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

Conversation Ask Anything
1

Let’s discuss! “Share a Tiller hack that took you way too long to figure out. Help someone else skip the struggle!”

2

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!

3

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.

4

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.

5

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

Reference guides I’ve been collecting:

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”.

6

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 *”)