Glad to know the above is almost what you’re looking for.
Changing to a range of price is pretty easy with the addition of 2 more columns.
Create 2 more columns in glide of type math. One is a LowBoundary and one is a HighBoundary, which for my example multiplies the users selected price by 0.8 and 1.2 respectively, giving 20% variance on either side (this of course can be any percentage you would like to put in depending how many results you want to return).
Then in your match column, instead of the last IF shown above enter the 2 following IFs instead:
- IF (LowBoundary in user sheet) IS > (pref 3 in product sheet) THEN False
- IF (HIghBoundary in user sheet) IS < (pref 3 in product sheet) THEN False
the result should only make it to the ELSE condition if the price of the items falls WITHIN the high and low bounds set per user.
If you want to also display (in another list somewhere) items that are close to their range, but either too high or too low, again using a couple math columns to set the range and a new Match column to evaluate would do the trick. Just have a wider range for the “almost in your price range” list.
Hope that all makes sense!