# Action "Set columns" won't set boolean but strings as\[ 'TRUE \] \[ 'FALSE \] **URL:** \ **Category:** Report a Bug\ **Created:** [March 14, 2021, 3:59pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252 "2021-03-14T15:59:12Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Milan\_Balogh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/milan_balogh/32/22918_2.png) [@Milan\_Balogh](https://community.glideapps.com/u/Milan_Balogh)\ **Post date:** [March 14, 2021, 3:59pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/1 "2021-03-14T15:59:12Z")
This only happens when using the action ‘Set columns’. It’s impossible to set Boolean values. **The examples below were tested with lowercase too, doesn’t make any difference.** Here is the action: ![setc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/3/638463674e4f07e8ac5b81662b7411c737f22b62.png) Here is the result: **Only the last row was change by an Action, the other 2 by switches (and had no issue and is the expected result)** ![sheet-true](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/8703584b0eaf75f73c0963fa5f4714b3ff59df1e.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0a1977c7228a883f1e26967196f056a7b7b64fab.png) All columns are set up as Boolean: ![setup](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/77b84f3414b53b497290b10b0611be2f625406ef.png) Here is an example of the issues it causes: ![array](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e0f7acbce62c40e3fc0e799ca42a7e28378f224.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 14, 2021, 4:12pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/2 "2021-03-14T16:12:23Z")
Is the column set up as a boolean column in the glide data editor? You might be better off just doing that logic in glide instead of using sheet formulas. PS. I’ve had good luck using lowercase true or false. ---
**Author:** ![Milan\_Balogh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/milan_balogh/32/22918_2.png) [@Milan\_Balogh](https://community.glideapps.com/u/Milan_Balogh)\ **Post date:** [March 14, 2021, 4:18pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/3 "2021-03-14T16:18:58Z")
Yes! (Updated the post) ---
**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 14, 2021, 4:20pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/4 "2021-03-14T16:20:38Z")
Try setting 1 or 0 for true or false. ---
**Author:** ![Milan\_Balogh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/milan_balogh/32/22918_2.png) [@Milan\_Balogh](https://community.glideapps.com/u/Milan_Balogh)\ **Post date:** [March 14, 2021, 4:25pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/5 "2021-03-14T16:25:17Z")
It’ll pass the values to sheets as is, and I needed them as plain TRUE/FALSE to make formulas work. Also, formulas will force uppercase for boolean in sheets. This works well if I just uncheck or check anywhere else, they will write the correct value without the apostrophe; It works with checkbox, it works with switches etc: ![data](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e5bc52caf014f67465108f2b920c2881d0f8c881.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 14, 2021, 4:34pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/6 "2021-03-14T16:34:20Z")
Can you explain why you are doing these formulas in the sheet instead of within glide? Sheet formula’s are going to introduce delays to show the results in the app. Doing it in app will be much more responsive. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [March 14, 2021, 4:51pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/7 "2021-03-14T16:51:12Z")
Not sure this helps, but this demo app shows how to use the set columns feature with Boolean columns. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a025e22a761b66340aa5e8e1d69ec9a1d63266c1.jpeg "Clear column app in Glide") ](https://www.youtube.com/watch?v=HnfdqrBDNKg) [https://willing-sense-6946.glideapp.io/](https://willing-sense-6946.glideapp.io/) ---
**Author:** ![Mishta\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mishta_p/32/16900_2.png) [@Mishta\_P](https://community.glideapps.com/u/Mishta_P)\ **Post date:** [March 14, 2021, 6:37pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/8 "2021-03-14T18:37:58Z")
@Darren_Murphy helped me with this the other week. When setting the values as text, set them in lower case. I’m not sure about Google sheets, but the glide sheets didn’t recognise the capitalised text. ---
**Author:** ![Milan\_Balogh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/milan_balogh/32/22918_2.png) [@Milan\_Balogh](https://community.glideapps.com/u/Milan_Balogh)\ **Post date:** [March 15, 2021, 10:51am UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/9 "2021-03-15T10:51:29Z")
I stated this at the beginning, I tried it with lowercase, makes no difference, it’ll pass it with an apostrophe: (And even if it didn’t, I wouldn’t be able to use any formulas with boolean logic, as sheets will always force uppercase boolean in the formula and ignore the lowercases in the cells) It should be consistent with the switch/toggle behaviour which writes TRUE and FALSE uppercase therefore recognised by sheets as boolean (or sheets autocorrects lowercase without apostrophe to uppercase automatically under the hood) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0a1977c7228a883f1e26967196f056a7b7b64fab.png) ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 15, 2021, 12:58pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/10 "2021-03-15T12:58:23Z")
Try having a single value column in your sheet which comes from a boolean column elsewhere. Use that single value in your set columns action. ---
**Author:** ![Milan\_Balogh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/milan_balogh/32/22918_2.png) [@Milan\_Balogh](https://community.glideapps.com/u/Milan_Balogh)\ **Post date:** [March 15, 2021, 2:01pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/11 "2021-03-15T14:01:10Z")
So this is obviously a bug and the workaround is cumbersome, but at least works (thanks @Manan_Mehta ) Create a boolean value somewhere for both TRUE and FALSE: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b810943a89cdc9fe8105e7debe06d60f0befc28c.png) Go to the same table you’d want to write boolean values to by a ‘Set columns’ action and create a Singe value column pulling in the boolean value: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3e98b12d9eb37a42dd30d34815c135f87dd8acc.png) Then assign these instead of typing (TRUE or true, doesn’t matter, it would pass it onto sheets with an apostrophe 😠): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d77a0a1797e3fdd917a40221bad9680676550222.png) **My suggestion for a fix would be:** ![booleanfix](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d1e6ba848c31c3b0e7fc10a145c1a2c72c7b09b.jpeg) ---
**Author:** ![fabio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabio/32/16336_2.png) [@fabio](https://community.glideapps.com/u/fabio)\ **Post date:** [March 20, 2021, 1:55pm UTC](https://community.glideapps.com/t/action-set-columns-wont-set-boolean-but-strings-as-true-false/24252/12 "2021-03-20T13:55:14Z")
Dear @Milan_Balogh , I have the same bug since few weeks, and it was reported in november but nobody seems to take care of this…the issue, as far as I understand, may be due to the fact that set column value is considered as text and not as Boolean value…but no solution has been provided yet, as far as I know. True/true/TRUE does not make any difference… I “solved” my issue giving to each Google sheets formula that was using a Boolean condition an OR formula… For example "=if (OR(a2=TRUE;A2=“true”);then;else)… But this is again a workaround which should not be used in my opinion. Greetings from Italy