IF function

I am trying to reference another sheet using IF but maybe its the wrong function.

First sheet is showing if an employee has completed an internal learning module that has 5 parts to it (these parts may change so do not want the formula to count the parts completed), the column has Yes when the module is completed. If that shows YES then in the other sheet I want to have "1" reflected in the column on the second sheet (that then affects another sheet, so want this sheet to automatically update when the module is passed on the first sheet).

I have tried =IF({IT Core Badge Range 2} = "Yes", 1, 0) and get INVALID OPERATION

Best Answer