Hi,
We have several credit cards whose balances come and go. I searched for a way to dynamically hide the 0 balance items. Here’s what I did:
On the Accounts sheet, I removed the validation on the D column and put the following formula in D2
=if(vlookup(A2,{$F$2:$F,$I$2:$I},2,false) = 0,"Hide","")
In words: Find the account name (A2) in the 2-column range that contains the account name (F) and last balance (I), if the balance is 0 put “Hide” into the cell.
Now, there may be side-effects that may exclude transactions from the hidden accounts in other sheets, but that’s for another session.
Hi @ramerkw I’m very curious to know in the long run if this works. As I was reading your post I was thinking this sounded very clever. I don’t see why it wouldn’t work… a fun experiment!
-Alice
Tiller Evangelist
Bluesky, Instagram, Facebook, LinkedIn
One side effect is that the Net Worth history will also be affected.
Consider this alternate method that only affects the Balances sheet 
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.
Our CC debt (fortunately ) is less than 10% of our Liability side. The Hide will be dynamic when transactions raise the CC balance. My goal is to have them at 0 balance the majority of time and most are. I can accept the trade-off for the Net Worth.
