I have created a formula field on an object (Object_A__c) which needs to get the data from another Object (Object_B__c). The relationship is such that both objects A and B have lookup relationship with each other.
The formula field has been created successfully however on the record detail page, the formula field shows blank.
I checked all the premissions and checked the field from Object B whose data has been rolled up but the data still shows blank on Obejct A's record detail page. I also ran a query on workbench but the data is visible on workbench. Not sure why not on SF. There are other lookup/Master-Detail fields (say Object_C__c) in Object A whose data is being rolled out if used in a formula (like Object_C__r.Name). But not in case of Object B.
Below is the Text type formula field I have created to fetch the data. Object_B__r.Message__c.