Forum Discussion

LaurenTurner's avatar
LaurenTurner
Qrew Member
5 years ago

Formula Checkbox Help

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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------
    • LaurenTurner's avatar
      LaurenTurner
      Qrew Member
      5 years ago
      That worked perfectly! Thank you so much for your help!

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