What formula should an app builder use to achieve the desired result?

Ursa Major Solar wants to see the Type field from the parent object Galaxy listed on the child recordStar. The app builder is receiving an error stating "Picklist values are only supported in certain functions".

What formula should an app builder use to achieve the desired result?
A . ISPICKVAL(Galaxy__r.Type__c)
B . VALUE(Galaxy_r.Type__c)
C . TEXT(Galaxy_r.Type_c)
D . FIND(Galaxy__r.Type__c)

View Answer

Answer: C

Explanation:

TEXT() is a formula function that converts a picklist value to text. This can be used to display the Type field from the parent object Galaxy on the child record Star. ISPICKVAL() is used to check if a picklist value is equal to a specified value. VALUE() is used to convert text that represents a number to a number. FIND() is used to locate one text string within another text string.