I need to add a formula to check box column if SSN is in 2 different SmartSheet.

Camelia C.

Paul Newcome

Ok. And do you want to check the box if it is in both, or does it only need to be in at least one?

Paul Newcome

Is this formula in a third sheet or is it on one of the 2 sheets mentioned?

Camelia C.

On a third sheet

Paul Newcome

Ok. And do you want to check the box if it is in both, or does it only need to be in at least one?

Camelia C.

yes I want to check the box if its on both

Paul Newcome

Ok. In that case (assuming the SSN is also in this 3rd sheet where the formula is), give this a try:

=IF(AND(COUNTIFS({1st Sheet SSN Column}, @cell = [SSN Column]@row) > 0, COUNTIFS({2nd Sheet SSN Column}, @cell = [SSN Column]@row) > 0), 1)