The population of ABC fields depends on field__r.Account__r.Name field.
I want to assigned ABC formula field with field__r.Account__r.Name value if field__r.field__c is blank,
but if there are some values in field__r.field__c then ABC field should be OpportunityName__r.Account.Name value
So I tried this...
IF(ISBLANK(field__r.field__c), OpportunityName__r.Account.Name, field__r.Account__r.Name)
Is it achievable using formula fields? thanks