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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
try this

IF([Tier Stage] = "Active" and [Weight] > 24, true)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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 QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
:)
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.