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
-
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})
Answers
-
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})
-
Totally worked! Thank you!