Hi everyone,
I need help with a formula that can identify names on one sheet and create true value to the main as the master sheet.
This is based on google classrooms with students submitting work. When they submit work, it shows the timestamp and names.
I would like to create a master list of all the students throughout the whole grade and add a value complete or incomplete by matching up names from the submission sheet.
Ideally, the master sheet will include weekly date task submission and have the column confirm their completion. The original google classroom sheet does not identify incomplete task.
Bookmarks