Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Simple checkbox formula

Topic Labels: Formulas
Solved
506 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.

Thanks for your help

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.

Thanks for your help

18 - Pluto

Right, I didn’t mean for you to take my formula literally by copying & pasting it into your solution — I meant for you to replace {Checkbox_Field} with the name of your own field.

I was giving you the STRUCTURE for how to create a formula using an IF statement.