Oct 11, 2021 01:44 PM
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)
Oct 11, 2021 05:24 PM
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).
Oct 11, 2021 06:32 PM
i mean you can definitely set up 24 check boxes and double the formula
Oct 11, 2021 06:34 PM
Since you’re already trying to store information about each individual payment, you should follow the base structure recommended by Kuovonne.