I have a list of courses that I want to display in a choice field. I have this working fine.
I then want to create an IMPORTRANGE from a sheet that holds information about the selected course.
Is there a way to run the IMPORTRANGE based on an individual user-specific selection in the Course choice field?
If I don’t have a user-specific selection then two members of staff will not be able to look up course details simultaneously.