I made a simple pivot table to look at each transaction within the category. It’s great except it’s not sorted by group, but by category. How would I sort it by group since it’s not a column in my transactions sheet? My rows are category, description, notes, amount. Then filtered to the latest month
Hi @wipersnaz - One possibility is to add the Group attribute to your Transactions sheet following the Tiller help article:
1 Like
That is exactly what i have done in mine but having trouble with having numerous array formulas like this one in my sheet was slowing down my fills from Tiller and ended erroring out a good portion of the time i added an if statement checking another cell for a checkbox true or false to turn the column off to save processing time/effort so my group column now looks like
Blockquote =if(J1=True,ARRAYFORMULA(IFERROR(VLOOKUP(D:D,Categories!A:B,2,FALSE),IFERROR(1/0))),“Group”)
With the checkbox located in J1