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 dat...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry 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
------------------------------
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
------------------------------
- That worked perfectly! Thank you so much for your help!
------------------------------
Lauren Turner
------------------------------
