Inline Filter: Ranges

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

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.

Hi @desetto ,
Here are two videos and screenshots to explain you how to do it.

1 Like