# Unable to Filter on Computed Column

**URL:** <https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432>\
**Category:** Ask for Help\
**Created:** [December 5, 2022, 1:57pm UTC](https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432 "2022-12-05T13:57:57Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![c7y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c7y/32/50824_2.png) [@c7y](https://community.glideapps.com/u/c7y)\
**Post date:** [December 5, 2022, 1:57pm UTC](https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432/1 "2022-12-05T13:57:57Z")

</div>

I’m trying to filter visibility based on a computed column in my table. There is definitely data showing in the column but the filter (which shows data when the column has data), is not working.

I understand that computed columns can’t be set as row owners, but I thought it was possible to use computed columns for visibility filters. Am I missing something?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 5, 2022, 2:27pm UTC](https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432/2 "2022-12-05T14:27:16Z")

</div>

What kind of computed column? What’s not working?

---

<div class="post-metadata">

**Author:** ![c7y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c7y/32/50824_2.png) [@c7y](https://community.glideapps.com/u/c7y)\
**Post date:** [December 5, 2022, 6:31pm UTC](https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432/3 "2022-12-05T18:31:14Z")

</div>

Hey Jeff.

I have a column in my table that looks up the owner of the row (which is contained in a column called “owner”) and pulls in the email of who that owner has “shared” their data with from the main Users table. So the computed column contains emails of these “sharees”. I want the filter to look at that computed column and display only if the contents matches the logged in user’s email. In other words, I want the data to display only if the logged in user is the “sharee”.

Does that make sense?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 5, 2022, 6:43pm UTC](https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432/4 "2022-12-05T18:43:08Z")

</div>

If you are relating to a table that is under row ownership, then the user will only see related rows that they own. If they don’t own the row, then they have no way to access it…even through a relation.

---

<div class="post-metadata">

**Author:** ![c7y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c7y/32/50824_2.png) [@c7y](https://community.glideapps.com/u/c7y)\
**Post date:** [December 5, 2022, 7:16pm UTC](https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432/5 "2022-12-05T19:16:56Z")

</div>

The row has two row owner columns (called owner and sharee), so this user should have access to the data because of the latter. I’m actually trying to use the filter to hide the data in certain circumstances.

---

<div class="post-metadata">

**Author:** ![c7y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c7y/32/50824_2.png) [@c7y](https://community.glideapps.com/u/c7y)\
**Post date:** [December 5, 2022, 7:17pm UTC](https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432/6 "2022-12-05T19:17:53Z")

</div>

Aha I’ve got you now! You’re referring to the data I’ve pulled in. Understood, that now makes sense. Thank you - I’ll try and find another way…

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 6, 2022, 7:18pm UTC](https://community.glideapps.com/t/unable-to-filter-on-computed-column/55432/7 "2022-12-06T19:18:29Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
