Simple Business Dashboard not showing Tiller Balance

I can see the cause for confusion, @anilparikh1.

The forum-documentation says: “If your spreadsheet does not include any unreconciled manual transactions, the Tiller balance is not shown.” … but perhaps this is too buried.

I wrote the dashboard to hide the Tiller balance if there wasn’t a difference because I thought the Tiller balance would be confusing to (the majority of?) users who don’t use manual balances.

There is a formula in E20 that looks like this: =if(countif($AV$3:$AV,"<>0"),ARRAYFORMULA(IFERROR(VLOOKUP(row($AO3:$AO103)-Row($AO$3), {$AP$3:$AP, $AW$3:$AW}, 2, FALSE), iferror(1/0))),iferror(1/0))

If you want to make the Tiller column always present, just remove the initial IF statement. (Though I think there may be a bug— identified in another thread—in this formula that I need to fix this week… so you may have to make this change again soon.)

Good luck,
Randy

1 Like