Is there a way to add a Currency value for Formula Fields with Checkboxes?

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)

1 Like

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!!! :smiley: