# Switch button not translating to TRUE or FALSE on Google Sheet **URL:** \ **Category:** Report a Bug\ **Created:** [February 29, 2020, 1:05pm UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039 "2020-02-29T13:05:06Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Euwyn\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/euwyn_goh/32/3957_2.png) [@Euwyn\_Goh](https://community.glideapps.com/u/Euwyn_Goh)\ **Post date:** [February 29, 2020, 1:05pm UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/1 "2020-02-29T13:05:06Z")
Switch button not translating to TRUE or FALSE on Google Sheet. I’ve added switches on my layout and triggering/not triggering the switch when adding a dataset leaves the Google Sheet cell empty. ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [February 29, 2020, 2:33pm UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/2 "2020-02-29T14:33:43Z")
Does it have a visibility condition associated with the switch button data? ---
**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:** [February 29, 2020, 2:35pm UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/3 "2020-02-29T14:35:53Z")
Any screenshots? Are you viewing the details of a list item, adding/editing a record, using a form button? ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [February 29, 2020, 8:27pm UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/4 "2020-02-29T20:27:35Z")
What does your formula look like? ---
**Author:** ![Euwyn\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/euwyn_goh/32/3957_2.png) [@Euwyn\_Goh](https://community.glideapps.com/u/Euwyn_Goh)\ **Post date:** [March 1, 2020, 9:43pm UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/5 "2020-03-01T21:43:00Z")
Thanks everyone. I don’t have a formula/visibility condition in the TRUE / FALSE cells, I was under the impression that an active switch would input a TRUE and an inactive switch would input a FALSE on the assigned column. Here is a screenshot of my layout page with the switches if it helps: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/02ec7e3768222fdb7338a957d96342400bdf7b7b.png) ---
**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:** [March 1, 2020, 10:51pm UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/6 "2020-03-01T22:51:41Z")
@Mark I just tried this out myself. A switch or checkbox does not return a true/false value on Add. Seems to work on View or Edit. Can anybody else confirm? ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 2, 2020, 12:43am UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/7 "2020-03-02T00:43:52Z")
I’ll look into it. Thank you for reporting! ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 2, 2020, 1:13am UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/8 "2020-03-02T01:13:11Z")
The bug is that adding new edit components to an Add screen won’t take until you change the parent screen. That means the workaround is to do some trivial change in the parent list screen after changing the Add screen, and then undoing the change. Sorry about this, we’ll fix the problem. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 2, 2020, 4:46am UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/9 "2020-03-02T04:46:56Z")
This will be fixed in a few days. Apologies again. ---
**Author:** ![Euwyn\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/euwyn_goh/32/3957_2.png) [@Euwyn\_Goh](https://community.glideapps.com/u/Euwyn_Goh)\ **Post date:** [March 4, 2020, 11:52pm UTC](https://community.glideapps.com/t/switch-button-not-translating-to-true-or-false-on-google-sheet/5039/10 "2020-03-04T23:52:46Z")
Thanks @Mark!