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…

To display the value of a parent object's picklist field in a child object's formula field, the picklist value must be converted to a text data type. The TEXT() function is specifically designed for this purpose; it returns the API name of a picklist value as a text string. Using TEXT(Galaxyr.Typec) correctly retrieves the value from the parent Galaxy record's Type field and allows it to be displayed on the child Star record, resolving the "Picklist values are only supported..." error.

A. ISPICKVAL(Galaxyr.Typec) is syntactically incomplete. This function checks if a picklist has a specific value and returns a boolean (true/false), not the text value itself.

B. VALUE(Galaxyr.Typec) converts a text string that represents a number into a number data type. It is not used for retrieving the text label of a picklist.

D. FIND(Galaxyr.Typec) is syntactically incomplete. This function finds the position of a string within another string and is not used for displaying a field's value.

---

1. Salesforce Help Documentation, "Formula Operators and Functions T–Z":

Section: TEXT(value)

Content: "Converts a percent, number, date, date/time, or currency type field into text. Also, converts a picklist value to a text value with the API name of the value, not the label." This directly confirms that TEXT() is the correct function for converting a picklist value to text for use in formulas.

2. Salesforce Help Documentation, "Tips for Working with Picklist and Multi-Select Picklist Formula Fields":

Section: "Using Picklists in Formulas"

Content: "To return the API name of a picklist value in a formula, use TEXT(). For example, TEXT(Status) returns the API name for the Status picklist, such as 'New'." This provides a clear example and reinforces the correct usage.

3. Salesforce Help Documentation, "Formula Field Data Types":

Section: "Text"

Content: This section explains the text data type in formulas. The error message "Picklist values are only supported in certain functions" arises because a picklist is not a standard text type. The TEXT() function is the bridge to convert it to a compatible type for display.