Would be great if we could, in Configuration of Relation, set multiple values from multiple columns !?(for “Matches the value in:”) thanks

Check out this thread: [image] How to create a relation which compares with multiple columns in other sheet Ask for Help 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]

You can if you set up your columns as an array. For example, name the headings ‘Item 1’, ‘Item 2’, ‘Item 3’, etc. This will create a single ‘Item’ column that can be used to set up a relation using all ‘Item’ columns.

Thank you for answering the question. I am not sure if an array solves my problem. I should have explained with an example. Suppose that we have a datasets of football matches and there are two tables: Team and Match. In Team, we have simply one column for Name. In Match, we have match information such as Home Name, Away Name, Date, Venue, etc. I want to use Match's relation in Team for showing coming matches for a team in the team’s detail view. For now, I can only refer to either of home/away column, so I should create two relations separately: Home Relation and Away Relation. Therefore, I would like to create a relation that shows matches without filtering by home/away. I actually wanted to ask if it is possible to set two conditions (see highlighted) [スクリーンショット 2020-01-25 15.53.55]

Oh, I did not realize that we could make an array as a part of table! Thanks so much!

Relation from multiple values (Data)

Feature Requests

Jeff_Hager January 25, 2020, 12:03pm 4

Check out this thread:

Topic		Replies	Views
Creating Relation with a Relation and Column Ask for Help	6	883	December 28, 2020
Match multiple relations - stuck Ask for Help	4	369	November 4, 2022
How to create a relation which compares with multiple columns in other sheet Ask for Help	9	1387	December 3, 2019
Set Column Value Ask for Help	1	516	October 4, 2022
Comma separated values in a single sheets column to drive the match multiple relations in Glide? Feature Requests	13	2371	February 9, 2020

Relation from multiple values (Data)

Related topics