0

In order to remove the 'Change' link near the Owner in the Account Page Layout, a possibile solution for us was to create a text formula field showing only the Owner First Name + Last Name. Should be easy, BUT: I am trying with Owner.FirstName & " " & Owner.LastName and I get this error:

You have reached the maximum number of 10 object references on Account
You must remove at least 1 relationship(s) in order to save this Formula Field.
Related objects referenced in this Formula Field:

Owner

plus a reference to an awful formula field created i-dont-know-when by someone else that I cannot modify. I just want to understand: is the problem the other formula field or mine? Shouldn't the Account Owner be available for formulas since Spring '13? What am I doing wrong?

1

There is a soft limit on the number of formulas that you can use per object. This limit is based on your Salesforce edition. There are limits all across Salesforce from both a configuration and development perspective.

You can request that you have this soft limit increased from '10' to a higher limit. This request should be made either via Premier Support or via your Salesforce account manager. For example, the soft limit of fields per object that can be marked for tracking history is typically 20 but this can be increased to as much as 50. From here, it seems that the limit could be increased to 20 or more.

However, just because the soft limit can be increased, it doesn't mean that it should. This answer from Salesforce Stack Exchange gives some useful detail.

As for why you cannot edit the other formula, it would be worthwhile checking to see if it is a dependency for an installed package. Of course, you can also a log a case to Premier Support.

Thanks

  • So do you think this is caused by the other formula? Cause I was able to create other formula fields on Account after that monster was created :( thanks for your answer – tony danza Sep 14 '15 at 9:12
  • Are those formulas related to other objects? Your formula in this question is related to the Owner object (User). Your formula in this question is a cross-object formula: help.salesforce.com/… – Andy Hitchings Sep 14 '15 at 9:17
  • No, the other formula is related to the Parent Account – tony danza Sep 14 '15 at 9:30
  • Right, so because your formula in this question (Owner.FirstName & " " & Owner.LastName) is related to Owner, it is a cross object formula and you cannot create it because you are already at the limit of cross object formulas. If the other formula you created is not a cross object formula, then that would explain why you could successfully save that formula. The limit you are hitting is related to cross object formulas, I believe. More info in the aforementioned link. – Andy Hitchings Sep 14 '15 at 9:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.