Cross-Sheet Duplicate Checkbox

Christina Riot

I have found a few things via smartsheet community on this but I just cannot get this formula to work. I am working fast and furious, so maybe I'm missing something obvious. I am trying to look up a badge number from one sheet and match it on another and if match, check the box. This is what I have:

=IF(COUNTIF(Badge@row, {HRCovidLeave Range 1}) > 0, 1)

Paul Newcome

Swap the range and criteria in your COUNTIF.

=IF(COUNTIF({HRCovidLeave Range 1}, Badge@row) > 0, 1)

If you are using a checkbox column, you could shorten it a little by using a standalone CONTAINS function as well.

=CONTAINS(Badge@row, {HRCovidLeave Range 1})

Paul Newcome

Swap the range and criteria in your COUNTIF.

=IF(COUNTIF({HRCovidLeave Range 1}, Badge@row) > 0, 1)

If you are using a checkbox column, you could shorten it a little by using a standalone CONTAINS function as well.

=CONTAINS(Badge@row, {HRCovidLeave Range 1})

Christina Riot

Totally worked! Thank you!