Calculations based on checkboxes (monthly payment tracker)

[Anxious]

So I have a payment tracker in google sheets and am trying to figure out how I can get it to work similarly in Airtable. Below is an image of my google sheet. Everything in red has a formula.

The “Monthly” is calculated by dividing the total by the length.
The “Remaining” is calculated by multiplying the amount of the “Monthly” by the number of checkboxes, then subtracting that from the total.

Google “Remaining” formula:

=C3-(COUNTIF(E3:P3,TRUE)*D3)

[Anxious]

It is a layaway payment tracker. If the box is checked, that means a payment has been made and the monthly amount is deducted from the remaining total. Layaway lengths are 6,9,12, and 24 months.

The formula works fine, just the 24-month layaway will be a bit fiddly. Maybe I will stare at it later and see if I can come up with a new design. I also had a note on the google sheet with the transaction number for that payment (the little black triangles).

[Rebecca_Elam]

i mean you can definitely set up 24 check boxes and double the formula

[Kamille_Parks]

Anxious:

I also had a note on the google sheet with the transaction number for that payment (the little black triangles).

Since you’re already trying to store information about each individual payment, you should follow the base structure recommended by Kuovonne.

kuovonne:

One way is to have two tables: one for [Accounts] and another for linked [Payments], with 1-24 linked payments, depending on the situation

Airtable Support

How to link records in Airtable

When you’re managing a workflow, there’s a lot of information to keep track of. Knowing which project connects to which client, or which venue you’re using for which event, is crucial to staying on...