# Dynamic Choice Component List

**URL:** https://community.glideapps.com/t/dynamic-choice-component-list/1295
**Category:** Ask for Help
**Created:** [October 20, 2019, 10:23pm UTC](https://community.glideapps.com/t/dynamic-choice-component-list/1295 "2019-10-20T22:23:13Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![James\_Castleden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james_castleden/32/692_2.png) [@James\_Castleden](https://community.glideapps.com/u/James_Castleden)
#### Post date: [October 20, 2019, 10:23pm UTC](https://community.glideapps.com/t/dynamic-choice-component-list/1295/1 "2019-10-20T22:23:13Z")

</div>

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)?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1660194cf6b463d6ec89cf7cd72d736d207e637d.png)

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!

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [October 21, 2019, 12:01am UTC](https://community.glideapps.com/t/dynamic-choice-component-list/1295/2 "2019-10-21T00:01:30Z")

</div>

![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6e41dae7ad3cc99a79af1737d9ea7ecb8590a2ee.png)

---

<div class="post-metadata">

### Author: ![James\_Castleden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james_castleden/32/692_2.png) [@James\_Castleden](https://community.glideapps.com/u/James_Castleden)
#### Post date: [October 21, 2019, 6:17am UTC](https://community.glideapps.com/t/dynamic-choice-component-list/1295/3 "2019-10-21T06:17:30Z")

</div>

Thank you so much, George!
