Check Register - show current balance on another Table?

t quinn wrote:

Hi Jgrizzle33,

Here is one way.

https://discussions.apple.com/content/attachment/2a41f271-973e-433d-af84-4ce034ed196d

INDEX(Table 1::E,MATCH(DATE(2200,1,1),Table 1::A,1))

This grabs the balance from the date closest to 1/1/2200.

quinn

This solution will break in 180 years. I believe this is how the Y2K bug started. 🤣

Hi Jgrizzle33,

Glad that is working for you.

About the other. A cell can have either data entry or a formula result.

I don't see a formatting solution that would add your "-".

However, you could modify your formula in the Balance column to subtract a positive entry in the Debit.

I then formatted everything in the Debit column to be red.

quinn

Here's a simple approach based on the old Numbers 2.3 template (no longer included with Numbers):

The formula in B2 is:

=INDEX(Transactions::F,COUNTA(Transactions::F)+3)

It assumes no blank rows within your body rows. The 3 is the number of Header Rows.

You can download the document here (Dropbox download). It includes the original template.

SG

Hi Jgrizzle33,

Here is one way.

INDEX(Table 1::E,MATCH(DATE(2200,1,1),Table 1::A,1))

This grabs the balance from the date closest to 1/1/2200.

quinn

A more robust Balance formula:

E$2+SUM(C$2:C3)−SUM(D$2:D3)

q

I have it in my calendar to update it in 150 years. No sense leaving it to the last minute.

q