Forum Discussion

ZanaSkenderi1's avatar
ZanaSkenderi1
Qrew Member
2 years ago

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 checked all, date and no date. 

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

Any help would be appreciated.

thank you

------------------------------
Zana
------------------------------
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    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
    ------------------------------
    • ZanaSkenderi1's avatar
      ZanaSkenderi1
      Qrew Member
      2 years ago
      thank you so much, that worked, I knew I had the null in the wrong place.

      ------------------------------
      Zana Skenderi
      ------------------------------