JackWoods

4 years agoQrew Trainee

# 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 it will look thing like...

If([Checkbox Field]="Checked",1,0)

This doesn't seem to work... error message is

"the operator = can not be applied to types bool"

please advise how I can set this formula field up - Thank you!

------------------------------

Jack Woods

------------------------------

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 it will look thing like...

If([Checkbox Field]="Checked",1,0)

This doesn't seem to work... error message is

"the operator = can not be applied to types bool"

please advise how I can set this formula field up - Thank you!

------------------------------

Jack Woods

------------------------------