Inline Filter: Ranges

Ask the community
#1

Is there a way to add an inline filter by numeric range? For example, in Airtable I have a Currency field for prices. I want an inline filter for “Between $500,000 and $600,000” … if I add the standard inline filters, only record with exactly $500,000 or $600,000 would appear.

1 Like
#2

Try creating a formula in airtable that looks something like this:

IF(AND(Currency>500,000,Currency<600,000), “500,000-600,000”)

Basically we are trying to make a formula that will give us a result of true if it meets that multi-step condition at the AND formula.

#3

Hi @desetto ,
Here is a resource to explain you how to do it.

1 Like
#4

I tried accessing the videos / screenshots but they aren’t accessible. Has the link changed? Please help.

#5

I deleted the resources (Didn’t do it on purpose), please refer to the link to the new airtable table above