Question 21
Choose 1
Universal Containers has several new fields they've requested for the Opportunity Product
object.
What should an app builder be able to configure using a formula field?
Correct answer:
C. A combination of the Opportunity's Text and a Description fields.
Explanation:
Formula fields in Salesforce are powerful tools that allow you to:
Reference parent fields (via relationships)
Concatenate text, numbers, and dates
Apply logic using functions like IF(), TEXT(), CONCAT(), etc.
In this case, the Opportunity Product (technically the OpportunityLineItem object) can access fields from its parent Opportunity using relationship syntax like Opportunity.Name or Opportunity.Description.
So, combining two text fields from the parent Opportunity — such as Opportunity.Text_Field__c + " " + Opportunity.Description__c — is fully supported in a formula field.
❌ Why the other options don’t work:
A. A hyperlink to the parent Account of the parent Opportunity
Formula fields cannot traverse two relationships (i.e., from Opportunity Product → Opportunity → Account). You can only go one level up.
B. A Rich Text area field that uses HTML to bold certain characters
Formula fields do not support Rich Text formatting or HTML styling like < b > tags.
D. A mix of functions and concatenation of 10 Account fields and 10 Opportunity fields
You cannot access Account fields from Opportunity Product via formula — that’s two levels up.
Also, this would likely hit the formula character limit (3,900 characters for compiled size).
🔗 References:
Salesforce Help: Formula Field Limits and Capabilities
Trailhead: Formulas & Validations
Formula fields in Salesforce are powerful tools that allow you to:
Reference parent fields (via relationships)
Concatenate text, numbers, and dates
Apply logic using functions like IF(), TEXT(), CONCAT(), etc.
In this case, the Opportunity Product (technically the OpportunityLineItem object) can access fields from its parent Opportunity using relationship syntax like Opportunity.Name or Opportunity.Description.
So, combining two text fields from the parent Opportunity — such as Opportunity.Text_Field__c + " " + Opportunity.Description__c — is fully supported in a formula field.
❌ Why the other options don’t work:
A. A hyperlink to the parent Account of the parent Opportunity
Formula fields cannot traverse two relationships (i.e., from Opportunity Product → Opportunity → Account). You can only go one level up.
B. A Rich Text area field that uses HTML to bold certain characters
Formula fields do not support Rich Text formatting or HTML styling like < b > tags.
D. A mix of functions and concatenation of 10 Account fields and 10 Opportunity fields
You cannot access Account fields from Opportunity Product via formula — that’s two levels up.
Also, this would likely hit the formula character limit (3,900 characters for compiled size).
🔗 References:
Salesforce Help: Formula Field Limits and Capabilities
Trailhead: Formulas & Validations
