# Filter table based on Company, Role **URL:** \ **Category:** Ask for Help\ **Created:** [March 8, 2025, 1:04pm UTC](https://community.glideapps.com/t/filter-table-based-on-company-role/80585 "2025-03-08T13:04:23Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![RVR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rvr/32/85931_2.png) [@RVR](https://community.glideapps.com/u/RVR)\ **Post date:** [March 8, 2025, 1:04pm UTC](https://community.glideapps.com/t/filter-table-based-on-company-role/80585/1 "2025-03-08T13:04:23Z")
Hi! I’ve got a Users Table, with Name, Email, Role and Company I’ve got a Ticket Table, with all ticket information, Email, Role and Company I would like to make sure that everyone from Company A, can see all open tickets. Everyone from Company B, can only see their own tickets, unless their role is Admin. Then they can see everything from Company B. ---
**Author:** ![RVR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rvr/32/85931_2.png) [@RVR](https://community.glideapps.com/u/RVR)\ **Post date:** [March 8, 2025, 8:04pm UTC](https://community.glideapps.com/t/filter-table-based-on-company-role/80585/2 "2025-03-08T20:04:47Z")
Solved! I actually managed with an IF-THEN-ELSE column 😃 In my Ticket table **“Add Column”** and select **“IF-THEN-ELSE”**. - **IF** `User’s Company` **is “Company A”** → **Then output** `"Show"` - **IF** `User’s Company` \*\*is the same as the Order’s Company` **→** Then output** `“Show”` - **ELSE** → `"Hide"` Then a filter on my List: IF Computed Column (IF-THEN-ELSE) is “Show” ---
**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:** [March 15, 2025, 8:05pm UTC](https://community.glideapps.com/t/filter-table-based-on-company-role/80585/3 "2025-03-15T20:05:26Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.