I am trying to figure out if it is possible to a column in Table1 show matching names from Table2 based on those names falling into a date range specified on Table 1. I'll try to explain further:
Table 2 will have the data:
Entity | Start Date | End Date
And Table 1 will have 4 columns:
Person | Start Date | End Date | Matching Entity from Table2
For example, where Person 1 on Table 1 has a date range that overlaps with more than 1 Entity from Table 2, the "Matching Entity" column on Table 1 will list all Entities whose date ranges overlap with Person 1 (E.g. - "Entity1, Entity3, Entity 6")
Does anyone know if there is some way of accomplishing this with Airtable?