I have a weekly form that is required to be submitted each week a manager is in training through certification. I am working with two sheets: (1) MIT LLR (MASTER), which is sheet where all form submissions live and (2) MIT LLR Submission Tracker. The tracker sheet consists of 1 column that contains cell links to auto-populate each new manager after their start date, followed by multiple Week columns that contain check boxes to verify the form was submitted each week.
What I am looking for is a formula that will auto-check the applicable Week # column if the form was submitted for that week, but will leave blank if the manager missed a the week by referencing the Last Name and Week # in the MASTER sheet.
Help Article Resources
Check out the Formula Handbook template!