Shouldn't the Salesforce formula contains only work if "account__r.lookup__r.Name" is contained in text_field__c?
I have a checkbox formula that evaluates true if: Contains(Text_field__c, Account__r.lookup__r.Name)
If I have "test account" in the account__r.lookup__r.Name, and "test account" in the text_field__c it works. However, if I leave it blank, or type in a random word for text_field__c that does not match account__r.lookup__r.Name and vice versa, it still marks it as true. Shouldn't contains only work if "account__r.lookup__r.Name" is contained in text_field__c?
I found a work-around to this. I just carried over the lookup__r.name into a formula field onto the object with text_field__c. Then I used the salesforce formula contains there to evaluate it.