We had a list view of the current user's records. However, to tell whether the record is the user's, it is not defined by the owner field, instead, it is defined by a custom field.
So originally, our org has the below formula field to resolve this issue:
IF (AND(Ida_Typist_Assigned__r.FirstName = $User.FirstName, Ida_Typist_Assigned__r.LastName = $User.LastName), "Yes","No")
However, one of my users has reported timeout issue for this listview this morning. I am assuming this is caused by the filter based on this formula field - because it needs to calculate the value for the records.
Is there a way I can optimise this list view filter?