# Filter for Sheets Checkbox does not work **URL:** \ **Category:** Questions\ **Tags:** google-sheets, filters\ **Created:** [December 14, 2023, 10:26am UTC](https://community.make.com/t/filter-for-sheets-checkbox-does-not-work/21871 "2023-12-14T10:26:07Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![neomagic](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/neomagic/32/17683_2.png) [@neomagic](https://community.make.com/u/neomagic)\ **Post date:** [December 14, 2023, 10:26am UTC](https://community.make.com/t/filter-for-sheets-checkbox-does-not-work/21871/1 "2023-12-14T10:26:07Z")
My MAKE filters have gone haywire 🤯 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/6/568ace6cf0fa16d4aebfc6db0b8f4bf029e7295f.png) They look at regular Sheets checkboxes and interpret Boolean FALSE (see black mouseover on below screenshot) as `true`. Setting filter as Text operators won’t work either. Nor does typing TRUE or FALSE in the condition field. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/7/97a9f4327bb245e53d4c95b41b23f3179b042290.png) What is going on? ---
**Author:** ![Philippe\_Billet](https://avatars.discourse-cdn.com/v4/letter/p/dc4da7/32.png) [@Philippe\_Billet](https://community.make.com/u/Philippe_Billet)\ **Post date:** [December 14, 2023, 10:47am UTC](https://community.make.com/t/filter-for-sheets-checkbox-does-not-work/21871/2 "2023-12-14T10:47:38Z")
Hi @neomagic , Did you try to test with the string “TRUE” (or “FALSE”) according to your needs? PBI ---
**Author:** ![neomagic](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/neomagic/32/17683_2.png) [@neomagic](https://community.make.com/u/neomagic)\ **Post date:** [December 14, 2023, 10:59am UTC](https://community.make.com/t/filter-for-sheets-checkbox-does-not-work/21871/3 "2023-12-14T10:59:02Z")
Yeah, TRUE and FALSE as text strings work with a text oprator filter, but I am setting the checkboxes via AppSheet (Google’s GUI frontend for Sheets) so I need the checkboxes’ functionality. ---
**Author:** ![Philippe\_Billet](https://avatars.discourse-cdn.com/v4/letter/p/dc4da7/32.png) [@Philippe\_Billet](https://community.make.com/u/Philippe_Billet)\ **Post date:** [December 14, 2023, 11:36am UTC](https://community.make.com/t/filter-for-sheets-checkbox-does-not-work/21871/4 "2023-12-14T11:36:19Z")
You could use a mapping that transforms TRUE (resp. FALSE) as string into true (resp. false) as Make boolean, a [switch](https://www.make.com/en/help/functions/general-functions#switch--expression--value1--result1---value2--result2---------else--) should do the job. ---
**Author:** ![neomagic](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/neomagic/32/17683_2.png) [@neomagic](https://community.make.com/u/neomagic)\ **Post date:** [December 14, 2023, 12:08pm UTC](https://community.make.com/t/filter-for-sheets-checkbox-does-not-work/21871/5 "2023-12-14T12:08:59Z")
So I set the cells with text strings instead of checkboxes. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/d/7d5fbf3d6dd9e242e0cc02264ab27c64214c3197.png) Turns out the Yes/No toggle in AppSheet is able to change the text(!) to TRUE or FALSE. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/d/ed3c07b0a42b3d555a465cf98bed7d6fb045db2c.png) Still seems like a bug in MAKE to me, but the workaround is manageable, so thanks! ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/0/30a3cc41d89e59bb5406399eff736a80635ea9b5.png) ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [December 28, 2023, 1:07pm UTC](https://community.make.com/t/filter-for-sheets-checkbox-does-not-work/21871/6 "2023-12-28T13:07:51Z")