Formula Checkbox field based on a date field
Hi, I am trying to set up a formula checkbox field, I needed it to be checked if there is a date in a corresponding date field, if no date I want it to be unchecked. Here is what I have but it has...
Forum Discussion
Try this
IF(IsNull([Epic Agreement Sign Date]), false, true)
Which is the same as this
IF(not IsNull([Epic Agreement Sign Date]), true, false)
which is the same as this
IF(not IsNull([Epic Agreement Sign Date]), true)
But this is a boolean checkbox field so this is the same as all of the above
not IsNull([Epic Agreement Sign Date])
With a boolean you can simply make a statement and Quickbase will come back with if you are saying something that is true or false.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
IF(IsNull([Epic Agreement Sign Date]), false, true)
Which is the same as this
IF(not IsNull([Epic Agreement Sign Date]), true, false)
which is the same as this
IF(not IsNull([Epic Agreement Sign Date]), true)
But this is a boolean checkbox field so this is the same as all of the above
not IsNull([Epic Agreement Sign Date])
With a boolean you can simply make a statement and Quickbase will come back with if you are saying something that is true or false.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
thank you so much, that worked, I knew I had the null in the wrong place.
------------------------------
Zana Skenderi
------------------------------
------------------------------
Zana Skenderi
------------------------------
