Skip to main content

Hi All,


I’m working on a table that has a formula with a checkbox, my problem is while the formula works I want the value to be currency and formatting options are not available.











I would be most grateful for any thoughts on how to accomplish this.


Thanks in advance

Take the quotation marks away from the 0. Putting a number in quotes tells Airtable to read it as a string as opposed to a number, which is why you couldn’t format the results. Without the quotes you should be able to format the results as a currency.


You also don’t need the = 1 bit in the formula. Therefore: IF({eB GWD Checkbox}, {Sold Price} * .1, 0)

Take the quotation marks away from the 0. Putting a number in quotes tells Airtable to read it as a string as opposed to a number, which is why you couldn’t format the results. Without the quotes you should be able to format the results as a currency.


You also don’t need the = 1 bit in the formula. Therefore: IF({eB GWD Checkbox}, {Sold Price} * .1, 0)


Thanks again Kamille! You’re so smart! Wondering if you have time could you look at this post and give me your thoughts on this other dilemma I have?




Thanks again, so incredibly grateful for you!!! :grinning_face_with_big_eyes:

Terms & Conditions