How can I make a formula work across objects?
- Starting from the object hosting the formula, build a chained field reference to the field you want to use.
- Use the API Names of the objects and fields.
- Replace the terminating __c in the object API Names with an __r
Example
- To use the Current Salary Amount in a formula hosted on the Team Member object:
fHCM2__Current_Employment__r.fHCM2__CurrentSalary__r.fHCM2__Amount__c
For more information see Using formulas and merge fields.