IF/VLOOKUP/INDEX/MATCH/COLLECT

Kenny T.
Kenny T. ✭✭✭
edited 04/25/23 in Formulas and Functions

Hi all,

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.

(1) MASTER

MIT LLR Master.png

(2) Tracker

MIT LLR Submission Tracker.png


Best Answers

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!