Jul 12, 2019 02:24 PM
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
Solved! Go to Solution.
Jul 12, 2019 02:33 PM
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)
Jul 12, 2019 02:33 PM
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)
Jul 12, 2019 02:37 PM
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: