Formula Checkbox Help

Question

I need to make a formula to have the checkbox be checked if there is data in another field.

If Supplier End Date has no data in the box the checkbox will remain unchecked, but then if there is data in the box it should be checked. How would i make this formula statement? I haven't a clue how to make it.

------------------------------
Lauren Turner
------------------------------

MarkShnierYou · Answer

Try this. I assume we are checking a field which is a date field type.
The formula would be a formula checkbox field type.
.
IF(IsNull([Supplier End Date]), false, true)

But you can also write it more simply like this

not IsNull([Supplier End Date])

Both of those will give the same result.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community