An app builder wants to create a formula field on an Account to include data from related Contacts but is unable to find the relationship in the formula editor. What is a limitation of formulas that could be causing the issue?
A.
More than 5,000 characters in the formula.
B.
Contact end Account objects DO NOT have a Master-Detail Relationship,
C.
Unable to reference the child records.
D.
Formula field limit reached on the Account object,
The correct answer is C. Unable to reference the child records.
A formula field on Account cannot directly pull data from multiple related Contact records because Contacts are child records of Account. Cross-object formulas work by referencing fields through supported parent relationships, not by traversing from a parent record down to multiple child records. Salesforce documentation describes cross-object formulas as formulas that reference fields on related objects, especially parent records through relationships.
Because an Account can have many Contacts, Salesforce does not expose that child relationship in the formula editor as a single field reference. For summarized child data, the app builder would normally use a roll-up-style solution where supported, or automation such as Flow.
A is unrelated unless the formula has already exceeded character limits.
B is misleading because the core issue is not simply that Account and Contact lack master-detail; it is that formulas cannot directly reference child records.
D is not supported by the scenario.
===========
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit