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?