Cross-Sheet Duplicate Checkbox

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)

Best Answer