# Filter Inline List based on values on a host sheet **URL:** \ **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:** 7\ **Page:** 1
**Author:** ![Zirjay\_Villanueva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zirjay_villanueva/32/7614_2.png) [@Zirjay\_Villanueva](https://community.glideapps.com/u/Zirjay_Villanueva)\ **Post date:** [May 20, 2020, 1:38am UTC](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454/1 "2020-05-20T01:38:41Z")
Guys, need help… I’m working on an app that allows people to key in their current aircon unit model and I want to be able to show possible replacements based on several options that are on another sheet. I currently have an Inline List that pulls data from the list of options sheet, but the filter function only allows me to enter a fixed value: ![Inline List Filtering_1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7a6ca9322bb1ac8d743307840e1b93bd5338ccc2.jpeg) I want the filtering to be dynamic based on the key-in values by the user: ![Inline List Filtering_2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d88772ccfa2b78b90131d715aa1e62f307e7b8dd.jpeg) Is there a way to do this currently? Thanks, Zirjay ---
**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")
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] ---
**Author:** ![Zirjay\_Villanueva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zirjay_villanueva/32/7614_2.png) [@Zirjay\_Villanueva](https://community.glideapps.com/u/Zirjay_Villanueva)\ **Post date:** [May 20, 2020, 4:37am UTC](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454/3 "2020-05-20T04:37:11Z")
Thanks, Jeff. I’ve tried reading through your suggestions but it’s a whooshing a bit over my head. I’m trying a different approach now - I was able to list down the possible options that satisfies my conditions in a single cell in my google sheet, is there a way to make a relation between the different items in this one cell to the items in my database sheet? ![Inline List Filtering_4a](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/103efa24ccbe6fdb8841c71da615200cfe31be25.jpeg) ‘Match multiple’ doesn’t return any results: ![Inline List Filtering_5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/431b8511e29c5d26f4c3cb7166071a98042195bb.jpeg) Thanks again. Any help is much appreciated. Zirjay ---
**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 22, 2020, 12:09pm UTC](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454/4 "2020-05-22T12:09:05Z")
You can’t do a relation like that. You are trying to match a single model number to a big list of model numbers. That’s not an exact match, so the relation won’t return anything. There’s 2 ways to do this: One method is to create an array of columns (Model 1, Model 2, Model 3, etc) and create you relation against the array column (Model) that Glide creates. The second method is to Create a sheet with a model in one column and a similar model in another column. List all of these combinations going down. One for each row. Then create a multiple relation to that sheet following by a lookup column that will get an array of all associated models that you can use, just like the first method. ---
**Author:** ![Zirjay\_Villanueva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zirjay_villanueva/32/7614_2.png) [@Zirjay\_Villanueva](https://community.glideapps.com/u/Zirjay_Villanueva)\ **Post date:** [May 26, 2020, 2:26am UTC](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454/5 "2020-05-26T02:26:03Z")
Thanks Jeff, I discovered what you mentioned by accident when I used the ‘Split text to Columns’ function and just named the columns Option 1, Option 2, etc… ![Inline List Filtering_6](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/967616980a25c42e5e8e455356e909db48e7752b.jpeg) I was surprised when I saw the options listed under one column in Glide! ![Inline List Filtering_7](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c84ac6b5fe456a0f9c316dff66240769093c41d2.jpeg) So it’s working like how I want it in Glide, I just need to find a way to automate the splitting every time the sheet is edited. Thanks again, you’ve been very helpful! Zirjay ---
**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:** [May 26, 2020, 2:35am UTC](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454/6 "2020-05-26T02:35:53Z")
I think you can use an ARRAYFORMULA for that. Put in the cell below option 1. ``` =ARRAYFORMULA(IF(A2:A<>"",SPLIT(A2:A,","),"")) ``` The A2:A is replaced with the column you store the “Possible replacement models”. Can you tell me if it works? ---
**Author:** ![Zirjay\_Villanueva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zirjay_villanueva/32/7614_2.png) [@Zirjay\_Villanueva](https://community.glideapps.com/u/Zirjay_Villanueva)\ **Post date:** [May 26, 2020, 3:02am UTC](https://community.glideapps.com/t/filter-inline-list-based-on-values-on-a-host-sheet/9454/7 "2020-05-26T03:02:20Z")
Thanks ThinhDinh! I actually just used the “Split” function since the ‘Possible Replacement Models’ column already is an ARRAYFORMULA, and the required conditions are specified inside that column already. I didn’t know that there was a SPLIT command, and it does the job perfectly. It even deletes the other info listed under the different Options columns if the original list of options gets lesser. So thank you for suggesting this 🙏 ![Inline List Filtering_8](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8cb013c140145d917d0a45df9de44df1a1ed2354.jpeg)