Is it possible to create a sheet that automatically populates with transactions from certain category? For example, a sheet with all transactions that are in the discretionary group
Yes, pretty easy to do. Just use this formula, where W is your last column with data, and D is your category column, and “Food” is the name of the category you want:
=FILTER(Transactions!A2:W,Transactions!D2:D="Food")
1 Like