Linking a checkbox to a form return list
I have a form that my employees fill out each month that returns to a sheet. I have another sheet that tracks whether each employee has returned a form for each month. I want the tracking sheet to automatically check the box in the appropriate month column when it registers that the employee's name appears on the submitted form list for that month. Up to this point I've been manually checking the boxes as forms are submitted. I know it should be simple but I can't seem to find the right formula. Pictures below.
Form return sheet (called December Quiz):
Tracking sheet (called Monthly Tracking):
Help Article Resources
Check out the Formula Handbook template!