Yeah, that’s the achilles heel of the Filters, Visibility, and If-Then columns in my opinion. It would be so much easier if we could compare column to column or a parent detail column to a child list column. This is especially complicated when you want to compare ranges of numbers to a dynamic user set range. You can do this in a google sheet, but you aren’t going to have the instant results as the google sheet would have to process the results from the user’s selections. I do something similar with dates. My users create a date range. Then in another sheet I use a query to find all of the lessons taught by that user withing the specified date range. It’s not pretty, but I don’t need instant search results, so it works for me.
=unique(query(Lessons!A1:I, "select A, E, I where 1=2 " & concatenate(arrayformula(if(LEN(InvoiceBillingCycle!A2:A) = 0, "", " or E='" & InvoiceBillingCycle!A2:A & "' and I>=date '" & TEXT(DATEVALUE(InvoiceBillingCycle!B2:B), "yyyy-mm-dd") & "' and I<=date '" & TEXT(DATEVALUE(InvoiceBillingCycle!C2:C), "yyyy-mm-dd") & "'"))) & "",2))
You could do something similar if you chose, but like I said, it would not be fast.
Once consideration I can think of would be to categorize each user into an age category (21-25, 26-30, 31-35, etc.). Using IF-Then statements, you could place each user into an age category based on their age. When a user is searching for other users, they could set a filter for a certain age category. This value could be used in a relation column to find all of the other users in the selected age category. You would display the relation as a list. I do something similar in the Dynamic List Filter in https://concepts.glideapp.io/.
I just want to also add that Glide has a User Specific Data column in staging. I really need to play with it to fully understand it, but it’s my understanding that each user can have their own values, so these aren’t columns that are written to the sheet. This would be great for filtering, since you wouldn’t need to maintain a row for each signed in user.