Dynamic hiding of accounts with zero balance

Conversation
4

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.

4 Likes