Check a box if values appear on two sheets

deb_63_hydracor

Hi,

I'm trying to check a box if a Sales Force ID on my source sheet appears on another sheet This is the formula I'm using but am getting an "Invalid Operation" error.

=IF({Sales Force ID} = SalesForceID@row, 1)

Thanks!

Carson Penticuff

Try this one.

=IF(HAS({Sales Force ID}, SalesForceID@row), 1, 0)