Remove account from Balances, but retain data in Net Worth

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

7 Likes