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

Table

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 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.