Skip to main content
Question

Formula Checkbox field based on a date field

  • November 4, 2022
  • 0 replies
  • 305 views
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 checked all, date and no date. 

If ([Epic Agreement Sign Date] = null, false, true)

Any help would be appreciated.

thank you

------------------------------
Zana
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement