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

[CottageKeeper]

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

[Kamille_Parks · Accepted solution]

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)

[CottageKeeper]

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?

Datetime_diff need formula to return value as Days, Hours, Minutes Formulas

Hello Friends, Needing to use datetime_diff to return days, hours, and minutes. I can only get the days to return the value. Tried all different types of formula nothing is working. Any thoughts? [SS%201] [SS%202]

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