# Simple checkbox formula

Topic Labels: Formulas
Solved
726 3
cancel
Showing results for
Did you mean:  4 - Data Explorer

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!
Sarah

1 Solution

Accepted Solutions  4 - Data Explorer

I am getting the following error when I use this:

Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

But you led me in the right direction, thanks!!! The formula was IF({Pay (X)}=1,{Balance Due}).

I did also figure out that the formula for calculating the sum of all the bills for the field Bills to Pay Total.

3 Replies 3  18 - Pluto

For your “Amount to Pay” field, that needs to be a formula field that looks something like this:

`IF({Checkbox_Field}=1,Balance Due,0)`  4 - Data Explorer

I am getting the following error when I use this:

Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

But you led me in the right direction, thanks!!! The formula was IF({Pay (X)}=1,{Balance Due}).

I did also figure out that the formula for calculating the sum of all the bills for the field Bills to Pay Total.   