Checkbox Formula - Greater than

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I need to write the following formula for a checkbox field;

If [Tier Stage] = "Active" and [Weight] > 24, true.

The formulat I have in now returns no errors, but the boxes are not showing checked when criteria is true.

[Tier Stage] is a Text Field, [Weight] is numeric

Photo of Nikki

Nikki

  • 284 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
  • 1
try this

IF([Tier Stage] = "Active" and [Weight] > 24, true)
be sure about your "fence posts" -  you might actually want to be true on Greater Than or Equal to 24.

IF([Tier Stage] = "Active" and [Weight] >= 24, true)
Photo of Nikki

Nikki

  • 284 Points 250 badge 2x thumb
I have tried both formulas.  The field does not contain an error when saving, but no boxes are showing checked in the records that qualify.  Any ideas why?
On a record that is not checked, what value is on the field [Tier Stage] and it it possible it has a trailing or leading space in it.  What value is in  the field for weight?
Photo of Nikki

Nikki

  • 284 Points 250 badge 2x thumb
Thank you for making me think.  The value in the Weight field is a percent.  I changed from 24 to .2 and it's working great.   Thank you for your assistance.
:)
Photo of Johnny QuickBase

Johnny QuickBase

  • 300 Points 250 badge 2x thumb
This is great I had a similar problem and didn't realize I needed to change my formula to .xx.  Makes sense if the field is a percentage.