Checkbox Formula - Greater than

Question

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

quickbasecoachd · Answer

try this IF([Tier Stage] = "Active" and [Weight] &gt; 24, true)

quickbasecoachd · Answer

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

nikkiwalters · Answer

I have tried both formulas.&nbsp;&nbsp;The field does not contain an error when saving, but no boxes are showing checked in the records that qualify.&nbsp;&nbsp;Any ideas why?

quickbasecoachd · Answer

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.&nbsp;&nbsp;What value is in&nbsp;&nbsp;the field for weight?

nikkiwalters · Answer

Thank you for making me think.&nbsp;&nbsp;The value in the Weight field is a percent.&nbsp;&nbsp;I changed from 24 to .2 and it's working great.&nbsp;&nbsp;&nbsp;Thank you for your assistance.

Forum Discussion

Checkbox Formula - Greater than

Related Content

Formula checkbox using manual checkbox and lookup formula

Combining AND with OR in Formula Checkbox Field

Using Pipelines to Archive Records Based on Checkbox

Converting delimited text into checkboxes

Checkboxes