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 wan…

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 informat…

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	854	December 28, 2020
Match multiple relations - stuck Ask for Help	4	345	November 4, 2022
How to create a relation which compares with multiple columns in other sheet Ask for Help	9	1325	December 3, 2019
Set Column Value Ask for Help	1	507	October 4, 2022
Comma separated values in a single sheets column to drive the match multiple relations in Glide? Feature Requests	13	2327	February 9, 2020

Relation from multiple values (Data)

Related topics