Display records in between Start and End dates of another table

[kb9132]

Hi, I need some help creating a formula.

I currently have the following set up:

Table1

• Primary column = text
• Start column = date
• End column = date

Table2

• Primary column = date
• Notes column = text

In Table1, I’d like to display what Table2 records exist that are in between the Start and End dates for each Table1 record.

Any advice would be appreciated!

[ScottWorld]

That is not possible in Airtable. You might be able to create a custom Javascript to do something like that for you. The same question was asked in this thread:

Double IF condition with multiple rows Formulas

Hello all! I have a question. I would like to create a formula with 2 conditions. IF “Item” in row 1 = “item” in row 2 AND “P” in row 1 is equal to “P” in row 2 then “it’s ok” otherwise “it’s not” Do you think it’s possible? Thanks for your help! [example airtable 2]