Is there a way to dynamically update the "list" in the Dropdown List column type?
The use case is an application process with reviewers who will log their reviews. There will be multiple reviews per applicant. Applicants apply through a form in one sheet. The reviewers need to prepare their reviews in a different sheet through a for. Or, at least that is how it is set up right now. Ideally, the reviewer form will have a field "Applicant" with a dropdown list that captures the applicant names available in the first different sheet.