# Unexpected filter results from checkbox in Google Sheets

**URL:** <https://community.make.com/t/unexpected-filter-results-from-checkbox-in-google-sheets/91627>\
**Category:** Questions\
**Tags:** google-sheets, filters\
**Created:** [September 9, 2025, 4:26pm UTC](https://community.make.com/t/unexpected-filter-results-from-checkbox-in-google-sheets/91627 "2025-09-09T16:26:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rebecca\_Katz](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@Rebecca\_Katz](https://community.make.com/u/Rebecca_Katz)\
**Post date:** [September 9, 2025, 4:26pm UTC](https://community.make.com/t/unexpected-filter-results-from-checkbox-in-google-sheets/91627/1 "2025-09-09T16:26:36Z")

</div>

I am running a scenario that starts with data in a Google Sheet. One of the columns in the Google Sheet is a checkbox. The output correctly displays as TRUE or FALSE as seen in this screenshot:

 ![Screenshot 2025-09-09 12.16.38 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/d/ade779519e22305a767754335818a34e5e9bc80d.png)

The scenario then has a router, with filters directing the action to take: one route where Opt-out is true, and one route where it is false:

 ![Screenshot 2025-09-09 12.16.11 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/d/6d54135c35d9c51898babc790ab73ab9a8e228e9.png)

 ![Screenshot 2025-09-09 12.17.33 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/3/334648dd6a2e678d478524ae766bfee4fe03935c.png)

HOWEVER regardless of whether the checkbox is checked or not, it is passing through the opt-out = true filter.

As per usual when I am coming to this community for help, I would not be surprised to find that the error is something incredibly easy to fix, but I need help identifying what that error is.

Thanks!

---

<div class="post-metadata">

**Author:** ![Probotic\_Solutions](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/probotic_solutions/32/73347_2.png) [@Probotic\_Solutions](https://community.make.com/u/Probotic_Solutions)\
**Post date:** [September 9, 2025, 6:27pm UTC](https://community.make.com/t/unexpected-filter-results-from-checkbox-in-google-sheets/91627/3 "2025-09-09T18:27:18Z")

</div>

Hi @Rebecca_Katz,

1. **Set the fallback route to “No”** after the **Router** to ensure this filter is only used when conditions match exactly, and not as a backup/default route.
2. **Add a filter condition** using a **text operator** set to **“Equal to (case insensitive)”** and compare the value with either `"TRUE"` or `"FALSE"` to properly handle boolean like text inputs.

Let me know if you need further clarification!  
If this helps, kindly mark it as a solution 👍

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/a/da2f0b0f3e8e26d26867f621dad68bd4f663929f.png)

---

<div class="post-metadata">

**Author:** ![Rebecca\_Katz](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@Rebecca\_Katz](https://community.make.com/u/Rebecca_Katz)\
**Post date:** [September 10, 2025, 7:12pm UTC](https://community.make.com/t/unexpected-filter-results-from-checkbox-in-google-sheets/91627/4 "2025-09-10T19:12:27Z")

</div>

Changing the filter to a text condition instead of boolean solved the problem. Thanks!

---

<div class="post-metadata">

**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:** [September 24, 2025, 7:27pm UTC](https://community.make.com/t/unexpected-filter-results-from-checkbox-in-google-sheets/91627/5 "2025-09-24T19:27:02Z")

</div>