Well that was easier than I thought…
Just open up the hidden area on the right of the Balances template and add INDIRECT(Y16)<>0
into the filters for the Asset and Liability queries.
Final formulas in K3
and R3
should look like:
=iferror(sort(filter({INDIRECT(Y11),INDIRECT(Y12),INDIRECT(Y13)&if(isblank(INDIRECT(Y14)),""," ("&INDIRECT(Y14)&")"),today()-INDIRECT(Y15),Indirect(Y16)},indirect(Y17)="Asset",indirect(Y18)<>"Hide",indirect(Y16)<>0),2,true, 4, true, 3, true))
=iferror(sort(filter({INDIRECT(Y11),INDIRECT(Y12),INDIRECT(Y13)&if(isblank(INDIRECT(Y14)),""," ("&INDIRECT(Y14)&")"),today()-INDIRECT(Y15),Indirect(Y16)},indirect(Y17)="Liability",indirect(Y18)<>"Hide",indirect(Y16)<>0),2,true, 4, true, 3, true))
Best,
Randy