Checkbox Evaluates Differently

Question

I have a checkbox column [H-SD (Added)[ with this formula:

=IF([H-Supplier Type]@row  = "Individual", IF(COUNTIF({SD-EmailPrimary}, [Email (Primary)]@row ) > 0, 1, 0), IF(COUNTIF({SD-EmailPrimary}, [Organization (Email)]@row ) > 0, 1, 0))

In another column, i want to evaluate if that column is checked or not, so I put this formula:

=IF([H-SD (Added)]@row = 1, "Checked", "Not Checked")

In some rows, where [H-SD (Added)] is checked, the formula returns "Checked".

And in other rows, where [H-SD (Added)] is also checked, the formula returns "Not Checked"

The formula is the same in both TEST1 rows, and while [H-SD (Added)] is checked in both rows, the formula returns something different.

Any explanation for this???

Paul Newcome · Answer

Ah. Ok. Glad it is working for you now. I didn't notice any glitches like this yesterday, but I was having a lot of performance issues. Everything seemed to be running extra slow.

aschneiderheinze1025 · Answer

There must have been something quirkie yesterday because now the formula correctly returns "Checked" when the box in the other column is checked.

The text field column was just a test. I am writing a formula that does something different when the box is checked, but I wasn't getting consistent results yesterday. Now, it seems to be working fine.

Paul Newcome · Answer

Does it present the same results if you convert it to a column formula?

What is the reason for having both a checkbox and a text field indicating the same thing?