# Re: Calculations based on checkboxes (monthly payment tracker)

1399 0
cancel
Showing results for
Did you mean:
7 - App Architect

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.

``````=C3-(COUNTIF(E3:P3,TRUE)*D3)
``````
Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
12 Replies 12
7 - App Architect

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).

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100