Hello - I am very new to Airtable (meaning…this morning :)) and I’m very much a newbie to any kind of spreadsheet.
I’m trying to create a formula and am hoping I can get some guidance here . I’ve attached a screenshot to help illustrate what I’m trying to achieve - if the column Pay(X) is checked, then the amount in column Balance Due will be put into column Amount to Pay. Finally, the Amount to Pay should be totaled and put into column Bills to Pay Total.
Thanks in advance for any assistance that can be provided!