Filter doesn't work well with boolean variable

Questions
1

Hi everyone,

I have a problem with this filter when bundle 3 enters the filters.

Basically in the third condition of the AND, 1.Evento creato (E)=FALSE, the filter outputs TRUE even if the condition is not met (as you can see from the screenshot below, the value of 1.Evento creato (E) is TRUE).

Can you help me?

Screenshot1
Screenshot1453×490 24.7 KB

3

Hi @Frost .

Boolean comparisons must be made against {{false}} or /false (it turns pink when you do it).

Google Sheets search rows, which I suppose you’re using, returns strings.

You are actually comparing the STRING value ‘Evento creato’ with the string FALSE. If the string is not empty (in your case FALSE) the comparison returns a true-ish value.

Try using the Text comparison “Equals to case insensitive”.

Give it a try and let us know.

@damato

2 Likes
4

You’re right @damato, now it works perfectly fine!

Thank you very much!! :slightly_smiling_face:

2 Likes