Hi @tenaciousd ,
- Can I create multiple Balance History tabs that automatically update? I’d like one to just have monthly balances and another to have weekly balances.
As @heather says, only one Balance History sheet is available.
Another way to achieve what you are looking for would be to use the one Balance History sheet, and then use formulas to generate a weekly and/or a monthly balance sheet. Those new sheets should not be named Balance History, but they would use the data from the Balance History sheet.
One complication is that not every Account reports a balance every day. So you might not be able to search from the balance of each account on the last day of the month or week. You would need a formula that looks for the last day of the month or week’s balance per account. See how that’s done on the Accounts sheet. If it doesn’t find one, it uses the most recent balance before that date.
Creating such a sheet would take some thinking and experimenting and knowledge of using formulas, unless you want to manually add the data every week or month. That might be a lot of effort.
But I’m sure it would be possible to do it either automatically or manually.