Let’s discuss! “Share a Tiller hack that took you way too long to figure out. Help someone else skip the struggle!”
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!
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.
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.
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”.
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 *”)
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].”
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.