Remove Accounts from Balance sheet (or choose which Accounts it displays)- without Hiding Accounts!

[Mark.S]

Here’s another quite easy option that doesn’t add sheets or columns:

Dynamic hiding of accounts with zero balance

Here’s another option to consider, if you like the idea of using your Accounts sheet method - introduce a Hide Balance option and use that instead of Hide in your formula. Then for Google sheets Balances sheet, cells K3 and R3 change: indirect(Y18)<>"Hide" to: indirect(Y18)<>"Hide",indirect(Y18)<>"Hide Balance" This is similar to this Closed account share.