I would like to have one list of lessons. lessons are only visible to a user if assigned. how do i do this?
Add a second sheet of Assignments. Form button to assign a Lesson to a user. In the lessons sheet, do a relation > multiple Lookup of the user email. Lesson sheet is filtered where lookup is signed in user.