How to check a box if criteria is met on a second sheet?

Whitney Faulkner

Hello! I am hoping to get some help with a formula. I am working on building out a training tracking workspace. I have built a form to collect the unique employee ID (TCOLE PID) and which training course they are taking (in this case its 2096), that data comes into my "Sign In" sheet and I have a VLOOKUP pull in the remainder of the data I need from my primary employee data sheet such as name, email, etc. On my primary employee data sheet I have a column of checkboxes that titled "2096" and I want to find a formula that looks at the "Training Sign In" sheet for the unique employee ID (TCOLE PID) and the course number that I need (again, in this case 2096) and check the box, thus marking it as complete. Is this possible?

Primary Data Sheet - contains employee data:

Training Sign In Sheet - populated by a form:

Kelly Moore

Hey @Whitney Faulkner

Try this:

=IF(COUNTIFS({Training Sign In Sheet TCOLE PID column}, [TCOLE PID]@row, {Training Sign In Sheet Course Number column}, 2096)>0, 1)

Will this work for you?
Kelly

che.rabajante

Hello @Whitney Faulkner

Please try this:

Hope this helps.😊

che

Kelly Moore

Hey @Whitney Faulkner

Try this:

=IF(COUNTIFS({Training Sign In Sheet TCOLE PID column}, [TCOLE PID]@row, {Training Sign In Sheet Course Number column}, 2096)>0, 1)

Will this work for you?
Kelly

che.rabajante

Hello @Whitney Faulkner

Please try this:

Hope this helps.😊

che

Whitney Faulkner

Both formulas worked! I cant thank you enough!