[SalesForce] Access Parent object’s field in Child object using formula field

From your question I understand you require a formula field which will be populated based on the field named 'desc' present in both the parents. Also it should check if the field 'desc' is empty before using it.

• Let the parent objects be Parent1__c and Parent2__c and the child be Child__c.
• Parent1__c has a field named Desc1__c and Parent2__c has a field named Desc2__c.
• Child__c has a formula field named Desc__c.
• Formula for this child field Desc__c with return type Text will be like this:

IF( ISBLANK(Parent1__r.Desc1__c), Parent2__r.Desc2__c , Parent1__r.Desc1__c)

The above formula will check if Parent1__c object's Desc1__c field is blank or not. If blank then Parent2__c object's Desc2__c will be populated in the child object else Parent1__c object's Desc1__c will be populated.

I hope this helps.

Using the below formula in the custom formula field custom1__c

CASE(custom__c, 
"atom", "small", 
"molecule", "big", 
"organic", "material", 
"inorganic", "nonmaterial",
"" 
)