Help

Re: Show category by date range

Solved
Jump to Solution
1523 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Julia_Harrison
5 - Automation Enthusiast
5 - Automation Enthusiast

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!
table

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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.

See Solution in Thread

3 Replies 3

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

Justin_Barrett
18 - Pluto
18 - Pluto

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.

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