Edited Transaction Tracker to filter based on the transactions already filtered

Google Sheets Show & Tell
,
1

Hello! I’ve edited the Transaction Tracker by @yossiea to work with my workbook in Google Sheets to add a subset column (as generated by the Category Schedule sheet by @Brad.warren) and adjusted the filtering to be a little more dynamic (if Category is “X”, only the groups associated with Category “X” are also shown and so on).

Link to edited Google Sheet

I am by no means an expert and I used ChatGPT to help me with Prompts. If someone wants to use these edits (or help me refine/optimize them) it would be very much welcomed :slight_smile:!

1 Like
2

This was making my sheet super slow with the complex formulas so I spent some time and converted it to scripts. It has a couple second lag but my sheet overall is performing a lot better… if anyone has a better workaround to improve performance of either version I’d love to hear it!

LINK to updated/script version