A tricky case of inline lists on my conference app 🙏

[Jeff_Hager]

Would it help to use an array of columns? So like @kyleheney suggested, create a second column, but you would name the columns ‘Speaker 1’ and ‘Speaker 2’. This will automatically create a virtual ‘Speaker’ column that Glide will see. That virtual column can be used for relations. Just looking quickly, I think this would make sense to do on your Program sheet. This should allow you to create a relation from each individual speaker to each program that they are an individual or paired up speaker. This should also allow a relation from Program to all speakers for that program, whether there are 1 or 2 speakers.

Here another thread where this method was used:

How to create a relation which compares with multiple columns in other sheet

I need to solve this: Sheet A (games) has 2 Columns with, “Home team ID” and “Away Team ID” Sheet B (Teams) has a column with “ID of the team” I want to relate Teams to the games their in in ONE list. So I need relate Teams to 2 colums of Games which both can contain the team ID. Does anyone know a fix? Having a new sheet with a beast of an array-kind-of-formula is also good if this fixes it XD [SmartSelect_20191203-113718_Sheets] To [SmartSelect_20191203-113729_Sheets]