Skip to content
Share
Explore
Bidirectional linked relation to/from same table (but as a single column)
Play around with the selections for Column 1 to see if this is the workaround for you :)
Table
Name
Column 1
Column 2
Related rows (Column 1 + Column 2 calculated)
Name
Column 1
Column 2
Related rows (Column 1 + Column 2 calculated)
Row A
Row B
Row D
Row B
Row D
Row B
Row C
Row A
Row C
Row D
Row C
Row A
Row D
Row C
Row B
Row B
Row B
Row D
Row B
Row A
Row B
Row A
There are no rows in this table
Step 1
In your table, create a column that relates back to the same table (Column 1).
Step 2
In the column options for Column 1, click the ‘Create column’ button under Create linked relation. This will generate a second column (I’ll name the Column 2).
Step 3 (optional)
Go into the column options for Column 2 and turn of Allow Edits. (not necessary, but it simplifies using this process if you can only have one column thats editable)
Step 4
Now create another column that links to the same table (I’ll name this Related Rows). This will be a calculated column that combines Column 1 and Column 2. Go into the Calculate section for this column and put in the formula
SwitchIf(
[Column 1].IsNotBlank() AND [Column 2].IsBlank() , [Column 1],
[Column 1].IsBlank() AND [Column 2].IsNotBlank(), [Column 2],
[Column 1].IsNotBlank() AND [Column 2].IsNotBlank(), ListCombine([Column 1], [Column 2]).Unique())
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.