Taking and showing attendance for instructors in a class
I have a form that is used to take attendance for 6 weekly sessions. The form populates a contact list for each class and calculates each participants progress during the 6 weeks using a JOIN DISTINCT COLLECT Participant@row formula.
There are 3 different cohorts of the same class going on at the same time. I have a sheet with each cohort that I want to display when they there attendance for each session individually.
Basically when the form recieves that they attended "Class 1" , I want the attendance sheet to show a checkmark in the colomn dated for class one. But it has to match up with the participant from the form to the attendance sheet.