Skip to main content
Solved

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

  • July 12, 2019
  • 2 replies
  • 33 views
C
Forum|alt.badge.img+12

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

Best answer by Kamille_Parks11

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)

    2 replies

    Kamille_Parks11
    Forum|alt.badge.img+27

    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)

    C
    C
    Forum|alt.badge.img+12
    • CottageKeeper
    • Author
    • Inspiring
    • July 12, 2019

    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 & ConditionsAccessibility statement