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

If Statement w/ Checkbox & Sum

Topic Labels: Formulas
1156 2
Showing results for 
Search instead for 
Did you mean: 

I’m trying to create a column that will calculate commission on the Sales Price of a job for me, but only if the Commission checkbox is checked. But I can’t get it to work!

Here is what I have:
IF({Commission?} = 1, SUM({Paid (Sold)})*.1 , 0)

What did I do wrong? All it returns are $0.00 even if I have a Checkbox marked!

Thank you for your help!

2 Replies 2

With many fields, including checkboxes, testing for the presence of any data (like a check mark) doesn’t require anything to compare against. Just put the field name by itself.

Also, you only have one field in the SUM function, so SUM isn’t really necessary.

What you’re left with is this:

IF({Commission?}, {Paid (Sold)} * .1 , 0)

That worked!!! Thank you!