Handling "Deleted Row" in Lookups

When you have a lookup column, if the referenced row is deleted it isn’t removed but instead replaced with a phantom “Deleted Row”

This includes when using “Delete Everywhere” on a row.

I’ve tried filtering with the following formula, but it doesn’t work:

[Lookup Column].ToText().Contains("Deleted Row")

But it doesn’t filter to those rows (it did previously).

I’m updating this post with a doc that solved my problem using the solution @Pch provided below.

My specific issue was removing “Deleted Row” references in a Lookup Column to another table.

This doc adds a “Ghost” row as @Susan_M_Davis calls it and then cleans it out.

1 Like

Hi @Brian_Sowards :blush: !

Depending on your use case scenario, maybe IsFromTable() could help you here ? :innocent:


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.