# Converting Many Yes/No Questions to Toggles in Sheets

**URL:** <https://community.glideapps.com/t/converting-many-yes-no-questions-to-toggles-in-sheets/2768>\
**Category:** Ask for Help\
**Created:** [December 10, 2019, 4:55pm UTC](https://community.glideapps.com/t/converting-many-yes-no-questions-to-toggles-in-sheets/2768 "2019-12-10T16:55:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)\
**Post date:** [December 10, 2019, 4:55pm UTC](https://community.glideapps.com/t/converting-many-yes-no-questions-to-toggles-in-sheets/2768/1 "2019-12-10T16:55:02Z")

</div>

I have a jotform form which exports the answers to a sheet. I built an app from the sheet. This sheet has around 200 questions which begin with Yes or No and then an explanation…which I would like to convert the Yes/No part into a toggle button. However, I do not want to manually go through and create each and every toggle button if possible.

 ![convert-to-toggle](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/abbcad126557751bed48d6d5c7bde9f62aa56ac4.png)  
Is there a way or function inside sheets to Find/Replace those Yes or No questions and convert them all to toggles at the same time? Any help much appreciated…just trying to save some time…

---

<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:** [December 15, 2019, 2:38pm UTC](https://community.glideapps.com/t/converting-many-yes-no-questions-to-toggles-in-sheets/2768/2 "2019-12-15T14:38:50Z")

</div>

I think if you insert checkboxes into each of your yes/no columns in your sheet or have True/False values already populated in the columns, Glide will convert those into Switches in the app for Add/Edit mode when adding the sheet to the app.

---

<div class="post-metadata">

**Author:** ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)\
**Post date:** [December 16, 2019, 11:05pm UTC](https://community.glideapps.com/t/converting-many-yes-no-questions-to-toggles-in-sheets/2768/3 "2019-12-16T23:05:35Z")

</div>

Thank you … i will give that a try! Much appreciated