# Cannot filter Data Grid by computed If-Then-Else column (current month) **URL:** \ **Category:** Ask for Help\ **Created:** [January 9, 2026, 2:13pm UTC](https://community.glideapps.com/t/cannot-filter-data-grid-by-computed-if-then-else-column-current-month/85956 "2026-01-09T14:13:55Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Matej\_Malavasic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matej_malavasic/32/83370_2.png) [@Matej\_Malavasic](https://community.glideapps.com/u/Matej_Malavasic)\ **Post date:** [January 9, 2026, 2:13pm UTC](https://community.glideapps.com/t/cannot-filter-data-grid-by-computed-if-then-else-column-current-month/85956/1 "2026-01-09T14:13:55Z")
Hi, I have a table called “Koledar” with a proper Date column. I also created a computed column: - is\_tekoci\_mesec (If → Then → Else) This column returns true when the row date is in the current month. Problem: When I try to filter a Data Grid, Glide does not allow selecting the computed column (If-Then-Else) in the Filter Data options. I understand that computed columns might not be filterable, but I want to confirm the best practice. Questions: 1. Is it correct that Data Grid filters only work with basic (non-computed) columns? 2. Is the recommended approach to always filter directly by the Date column using “date is in This month”? 3. Is there any supported way to use a computed boolean for filtering, without copying its value into a physical column? Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 10, 2026, 2:23am UTC](https://community.glideapps.com/t/cannot-filter-data-grid-by-computed-if-then-else-column-current-month/85956/2 "2026-01-10T02:23:34Z")
Sounds like you’re using a Big Tables for the relevant table here. Can you confirm? ---
**Author:** ![Matej\_Malavasic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matej_malavasic/32/83370_2.png) [@Matej\_Malavasic](https://community.glideapps.com/u/Matej_Malavasic)\ **Post date:** [January 11, 2026, 11:08pm UTC](https://community.glideapps.com/t/cannot-filter-data-grid-by-computed-if-then-else-column-current-month/85956/3 "2026-01-11T23:08:55Z")
Yes, i use big tables. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 13, 2026, 12:41am UTC](https://community.glideapps.com/t/cannot-filter-data-grid-by-computed-if-then-else-column-current-month/85956/4 "2026-01-13T00:41:20Z")
So what you’re experiencing is a calculation limitation of Big Tables. I think you may want to try establishing 2 math columns in your Users table (not a Big Table), then try filtering your basic Date column to be on or after the “Month Start” date and on or before the “Month End” date to see if it allows you to do so. ---
**Author:** ![Matej\_Malavasic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matej_malavasic/32/83370_2.png) [@Matej\_Malavasic](https://community.glideapps.com/u/Matej_Malavasic)\ **Post date:** [January 15, 2026, 10:28pm UTC](https://community.glideapps.com/t/cannot-filter-data-grid-by-computed-if-then-else-column-current-month/85956/5 "2026-01-15T22:28:34Z")
Thank you, it works in a Blank Table and it also works with an If-Then-Else column. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 15, 2026, 11:48pm UTC](https://community.glideapps.com/t/cannot-filter-data-grid-by-computed-if-then-else-column-current-month/85956/6 "2026-01-15T23:48:58Z")
So you can confirm it works normally when you created a new Glide Table (not Big Tables)? ---
**Author:** ![Matej\_Malavasic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matej_malavasic/32/83370_2.png) [@Matej\_Malavasic](https://community.glideapps.com/u/Matej_Malavasic)\ **Post date:** [January 18, 2026, 9:11pm UTC](https://community.glideapps.com/t/cannot-filter-data-grid-by-computed-if-then-else-column-current-month/85956/7 "2026-01-18T21:11:40Z")
Yes, works normaly.