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

Camelia C. · 01/10/25

Paul Newcome · 01/13/25

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 · 01/10/25

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

Camelia C. · 01/11/25

On a third sheet

Paul Newcome · 01/13/25

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. · 01/13/25

yes I want to check the box if its on both

Paul Newcome · 01/13/25

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)

Best Answer