Show category by date range

[Julia_Harrison]

Hi,

I have a table with several categories and they all have a month assigned to them (essentially types of activities being undertaken in that month).

I want to create a view that shows one category across specific months. For example “Real Estate” in March, April and May. I can’t do it with filters, because I would need to combine AND OR filters. I saw a post about combining formulas: https://support.airtable.com/hc/en-us/articles/221561507-Combining-AND-and-OR-filters but can’t seem to write the correct formula for this.

I would really appreciate any help!

Thank you so much!

[ScottWorld]

Try the “Group” function, and you can group your categories by month and category.

[Justin_Barrett · Accepted solution]

Try this formula, changing the {Category} and {Month} field names to match your actual base:

AND(Category = "Real Estate", OR(Month = "03 - Mar", Month = "04 - Apr", Month = "05 - May"))

Or, slightly shorter:

AND(Category = "Real Estate", SWITCH(LEFT(Month, 2), "03", 1, "04", 1, "05", 1, 0))

Filter all records that output a 1.

[Julia_Harrison]

Justin_Barrett:

"Real Estate", OR(Month = "03 - Mar", Month = "04 - Apr", Month = "05 - May"))

Thank you so much - that’s exactly what I needed!