Checkbox Formula to give me a 1 or a 0
Hey hey I was trying to figure out the formula so that when I check a checkbox (In another field) it will give me either a one or a zero in this formula field that I'm trying to build. I imagine i...
Forum Discussion
I knew it was something silly. I was trying yes/no - checked/unchecked. everything else but True/False. thank you.
------------------------------
Jack Woods
------------------------------
------------------------------
Jack Woods
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendYou could have also just done this
If([Checkbox Field] ,1,0)
That is because [Checkbox field] is a boolean which means it's either true or false. So QB would evaluate the expression [Checkbox field] and it will either true or false on its own. But I recognize that the formula reads a bit easier for humans the original way I posed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If([Checkbox Field] ,1,0)
That is because [Checkbox field] is a boolean which means it's either true or false. So QB would evaluate the expression [Checkbox field] and it will either true or false on its own. But I recognize that the formula reads a bit easier for humans the original way I posed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Awesome - thank you for the breakdown
------------------------------
Jack Woods
------------------------------
