Net Worth Tracker Sheet Revised to Work With Groups

Hi @coltexman ,
It sounds like you want to take multiple Tiller spreadsheets (perhaps each looks at a different set of accounts) and combine them into a new spreadsheet that sums them all and generates a Net Worth?

(We generally use the term “Sheets” to refer to the individual sheets or tabs within a single spreadsheet, which is made up of multiple sheets.)

You could create a main spreadsheet and use IMPORTRANGE() functions to import the transactions and balance history sheets into the new sheet from multiple sources.

This link might help:

Then you would need to create a combined Transactions and Balance History sheet in the new Spreadsheet using some array functions to merge the imported individual sheets into one sheet.

Another simpler option might be to create a new Tiller Spreadsheet that pulls in all the accounts that you want in the rollup view.

Jon

1 Like