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

How do you filter for “Deleted Rows”?

What approach do you use to clean up these phantom records?

1 Like

Hi @Brian_Sowards :blush: !

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

3 Likes