Dynamic Choice Component List

Could anyone help with a sheets formula that updates the choice component list according to which elements have already been selected (ie, placed in Col. B)?

BONUS: a way to make sure that there is no conflict (the lag on Glide updating can allow students to select items on the list that shouldn’t be there!)

Thanks!

4 Likes

Thank you so much, George!