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
0
1
2
3
4
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.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.