# Check Box with multiple criteria

Hello -

I am trying to get a checked box: If Column A value = Column B value, check box. However, I am also getting checked boxes when A and B are both blank which should not happen.

Current formula is:

=IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row), 1, 0)

Is there a syntax I can add to say if A = B but A ≠ blank, then 1,0

Thank you

• The IF/AND is only used when simultaneous conditions exist. IF the formula was only A=B, we would not use AND.

But since you found that an additional condition is needed in order to obtain the expected result, the formula becomes:

=IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row, [TRACcess Serial Number as Per TRACcess Manager]@row<>""),1)

The <> means 'is not'. The double quotes mean blank. The formula reads if [TRACcess Serial Number as Per TRACcess Manager]@row equals [TRACcess Serial Number As Reported by Tech]@row AND the [TRACcess Serial Number as Per TRACcess Manager]@row is not blank, then 1. If these are not true then the formula does nothing, which will leave the cell blank.

Does this work for you?

Kelly

• The IF/AND is only used when simultaneous conditions exist. IF the formula was only A=B, we would not use AND.

But since you found that an additional condition is needed in order to obtain the expected result, the formula becomes:

=IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row, [TRACcess Serial Number as Per TRACcess Manager]@row<>""),1)

The <> means 'is not'. The double quotes mean blank. The formula reads if [TRACcess Serial Number as Per TRACcess Manager]@row equals [TRACcess Serial Number As Reported by Tech]@row AND the [TRACcess Serial Number as Per TRACcess Manager]@row is not blank, then 1. If these are not true then the formula does nothing, which will leave the cell blank.

Does this work for you?

Kelly

• Worked perfectly and you increased my knowledge base! Thank you @Kelly Moore!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!