Self-referencing Lookup column filtering current row

[Paul_Danyliuk]

Moreover, no need for Row ID

You can write CurrentValue != thisRow

In Filter() context, CurrentValue is the row being currently evaluated.

Also @Daniel_Srb for the bulletproof solution of your potential problem see:

Prevent circular dependencies when adding child-parent relationships

Sometimes there’s a need to build an object hierarchy, e.g. tasks with sub-tasks with sub-sub-tasks etc, with indefinite nesting. To implement this, you’ll add a lookup column Parent to your table, pointing to the same table. However, if you don’t filter the options for selecting a parent, you risk running into a circular dependency and select a parent row that is already a descendant. To prevent this and narrow down parent choices, do the following: Construct each item’s path: If( thisRow…