My best guess would be to select a job and an individual person, then submit use a form button to submit the job and name to a sheet. The other option is to build a sheet that contains each Job, Name and Availability. Then build a relation from the job details to the new sheet. Then you can add an inline list of names and you can check off each name that’s available for that job. It’s a lot of rows but would probably work the best.
@Robert_Petitto is using a method here that I’ve never seen before. I can’t fully see how he is doing it.
I’ve used the transpose method:
=transpose(split(concatenate(arrayformula(split(rept(unique(Coaches!B2:B) & "\|", countif(Choices!D2:D ,"<>")),"|"))),"\")) but it has limitations if the length of the string you are splitting and transposing gets too long (I think 50,000 characters)