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.
1 Like
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 
1 Like
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.
3 Likes
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.
