Filter for Sheets Checkbox does not work

How To
,
1

My MAKE filters have gone haywire :exploding_head:

image
image1012×790 58.9 KB

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
image1213×404 68.6 KB

What is going on?

2

Hi @neomagic ,

Did you try to test with the string “TRUE” (or “FALSE”) according to your needs?

PBI

2 Likes
3

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.

4

You could use a mapping that transforms TRUE (resp. FALSE) as string into true (resp. false) as Make boolean, a switch should do the job.

2 Likes
5

So I set the cells with text strings instead of checkboxes.

image
image637×698 33 KB

Turns out the Yes/No toggle in AppSheet is able to change the text(!) to TRUE or FALSE.

image

Still seems like a bug in MAKE to me, but the workaround is manageable, so thanks!

image

1 Like