# Dropdown in Sheet Getting Erased After User Edit in App

**URL:** <https://community.glideapps.com/t/dropdown-in-sheet-getting-erased-after-user-edit-in-app/16025>\
**Category:** Report a Bug\
**Created:** [September 18, 2020, 10:13pm UTC](https://community.glideapps.com/t/dropdown-in-sheet-getting-erased-after-user-edit-in-app/16025 "2020-09-18T22:13:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [September 18, 2020, 10:13pm UTC](https://community.glideapps.com/t/dropdown-in-sheet-getting-erased-after-user-edit-in-app/16025/1 "2020-09-18T22:13:47Z")

</div>

My app’s URL: [https://htechinv6425.glideapp.io/](https://htechinv6425.glideapp.io/)

For dropdowns that have been set up in Sheets, I’ve noticed that when I set it up in the app to edit as a Choice component, it erases the dropdown list in Sheets once a value is entered on the app. Is this a bug? Or is this the expected behavior? I’d really like to keep the dropdown in Sheets and not have it be erased if possible.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 18, 2020, 10:31pm UTC](https://community.glideapps.com/t/dropdown-in-sheet-getting-erased-after-user-edit-in-app/16025/2 "2020-09-18T22:31:22Z")

</div>

To me that’s normal, but I also view the sheet purely as a database without any sheet validation taking place. I know that’s not always the case and some people also have regular data entry through the app as well as directly through the sheet. I suppose it’s no different than doing a copy/paste over a cell that has data validation. That will remove the dropdown as well.

(PS. I have no idea how the Google API works and handles this)
