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.