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 thread: Inline Filter: Ranges - #7 by matthieu_chateau

6

Hi @matthieu_chateau, I have copied your formula into airtable but am unable to create field due to an error message stating the formula is incorrect. Here is a copy of the formula I hope to use, are you able to see if there are any errors? Thanks,

IF(AND({Purchase Price}>=£0,{Purchase Price}<=£50,000), ‘£0-£50,000’, IF(AND({Purchase Price}>=£50,000,{Purchase Price}<=£100,000), ‘£50,000-£100,000’, IF(AND({Purchase Price}>=£100,000,{Purchase Price}<=£200,000), ‘£100,000-£200,000’, IF(AND({Purchase Price}>=£200,000,{Purchase Price}<=£300,000), ‘£200,000-£300,000’, IF(AND({Purchase Price}>=£300,000,{Purchase Price}<=£400,000), ‘£300,000-£400,000’, IF(AND({Purchase Price}>=£400,000,{Purchase Price}<=£500,000), ‘£400,000-£500,000’, IF(AND({Purchase Price}>=£500,000,{Purchase Price}<=£650,000), ‘£500,000-£650,000’, IF(AND({Purchase Price}>=£650,000,{Purchase Price}<=£800,000), ‘£650,000-£800,000’, IF(AND({Purchase Price}>=£800,000,{Purchase Price}<=£950,000), ‘£800,000-£950,000’, IF(AND({Purchase Price}>=£950,000,{Purchase Price}<=£1,100,000), ‘£950,000-£1,100,000’, IF(AND({Purchase Price}>=£1,100,000,{Purchase Price}<=£100,400,000), ‘£1,100,000+’)))))))))))

7

Hi,

Can you use " " instead of ’ '? No big deal but could be easier to read at the end, and to be maintained.

Also you should not use “£0” etc. but 0 etc. I use pure numbers in my formula not numbers + currency

IF(AND({Purchase Price}>=0, {Purchase Price}<=50000), "£0-£50,000",
    IF(AND({Purchase Price}>=50000, {Purchase Price}<=100000), "£50,000-£100,000",
        IF(AND({Purchase Price}>=100000, {Purchase Price}<=200000), "£100,000-£200,000",
            IF(AND({Purchase Price}>=200000, {Purchase Price}<=300000), "£200,000-£300,000",
                IF(AND({Purchase Price}>=300000, {Purchase Price}<=400000), "£300,000-£400,000",
                    IF(AND({Purchase Price}>=400000, {Purchase Price}<=500000), "£400,000-£500,000",
                        IF(AND({Purchase Price}>=500000, {Purchase Price}<=650000), "£500,000-£650,000",
                            IF(AND({Purchase Price}>=650000, {Purchase Price}<=800000), "£650,000-£800,000",
                                IF(AND({Purchase Price}>=800000, {Purchase Price}<=950000), "£800,000-£950,000",
                                    IF(AND({Purchase Price}>=950000, {Purchase Price}<=1100000), "£950,000-£1,100,000",
                                        IF(AND({Purchase Price}>=1100000, {Purchase Price}<=100400000), "£1,100,000+",
                                            "Out of range"
                                        )
                                    )
                                )
                            )
                        )
                    )
                )
            )
        )
    )
)
8

Thanks for the quick reply, I have removed the £ and commas from the target range and swapped ’ for " and it has worked! Nice one mate