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
MarkShnier__You
Qrew Legend
Qrew LegendTry this
If([Checkbox Field] = true,1,0)
(as an aside, the opposite if true in this syntax would be false)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If([Checkbox Field] = true,1,0)
(as an aside, the opposite if true in this syntax would be false)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I knew it was something silly. I was trying yes/no - checked/unchecked. everything else but True/False. thank you.
------------------------------
Jack Woods
------------------------------- MarkShnier__YouYou 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
------------------------------- Awesome - thank you for the breakdown
------------------------------
Jack Woods
------------------------------
