# Filter Inline List based on values on a host sheet

**URL:** <https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454>\
**Category:** Feature Requests\
**Created:** [May 20, 2020, 1:38am UTC](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454 "2020-05-20T01:38:41Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [May 20, 2020, 1:46am UTC](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454/2 "2020-05-20T01:46:59Z")

</div>

Unfortunately we cannot compare 2 dynamic values in a filter or if/then column, although it has been requested several times. This would be best achieved with relations, but due to your use of greater than and less than compares, this further complicates things.

I would recommend reading up on these methods to get a better idea of how to do this. You’ll will most likely need to think of your logic backwards. Create relations, lookups, it/thens, etc. in the items sheet to pull in the selected value. Then create the proper relations in the selection sheet to match up. I hope this helps.:

> [@How to make an app like Zillow with advanced filtering](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517):
>
> Hey everyone! I’m starting a no code tutorial site called No Code MBA, initially focused on Glide, giving step by step instructions on how to build apps without code. The first tutorial I created is a real estate app like Zillow using Glide. The tutorial has 8 lessons (about 2.5 hours of content). You can access the tutorial for free at [nocode.mba](https://www.nocode.mba/courses/zillow) The tutorial includes: Advanced filtering to view homes User onboarding A “favorites” tab for homes If you are interested in this tutorial and yo…

> [@Conditional visibility of components usage question](https://community.glideapps.com/t/conditional-visibility-of-components-usage-question/1993/14):
>
> Hey guys, I’m trying to build a two-side marketplace at the moment looking at a few no-code options, but am loving playing in Glide and following all the new releases/ features. Initially I had two apps/ one spreadie, but am now trying to convert to one app, after I realised you can’t comment between them which I was using as a 121 chat function. I’ve had a few goes at this problem you’re talking about and one option seems to be working, but would like to know what you think and if it will sca…

> [@List Relation "Data"](https://community.glideapps.com/t/list-relation-data/7659/5):
>
> BAM! I figured it out. First create an If/Then column on the user profile sheet that fills the column with the word ‘Name’ if signed in user. Next, on every sheet you want to display the name: Create a template column that contains the word ‘Name’. Create a relation column that joins the name template to the name template in the user profile sheet. Create a lookup column that gets the name from the relation. Bonus - make it look pretty. [image] [image]

---

_[View the full topic](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454)._
