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.
Answers
-
Here are some Pics
Pic 1. The sheet the collects the attendance. If "Clase 1" is entered in the "Clase Asistida" coloumn for Testing Test participant, (Pic 2) then I want a checkmark or even just "Clase 1" to be entered in the coloumn with "Clase 1: 01/13/2021" that corresponds with the PARTICIPANT column.
Thanks
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives