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.