need help with a check box formula

System

This discussion was created from comments split from: Formula for a checkbox.

ssuser01

@Paul Newcome @BullandKhmer and Anyone else.

I need help with a check box formula. What I am trying to do is as follows:

If the row has a check box in this field create this icon in this box in another field And if the box is not checked then create this icon.

What I have for my formula right now is: =IF(AND([Field Name@row = 1), UNICHAR(9989), IF(AND([Field Name@row = 0), UNICHAR(9940)

kira11

Hi!

I think you should just be able to use the IF statement:

=IF(FieldName@row = 1, UNICHAR(9989), IF(FieldName@row = 0, UNICHAR(9940), ""))

Paul Newcome

Try this:

=IF([Field Name]@row = 1, UNICHAR(9989), UNICHAR(9940))