Have you ever ran into a problem when creating a formula field where you get the error that the compiled formula is too big to execute (i.e. "Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (7,498 characters). Maximum size is 5,000 characters.")? You might think that splitting the formula into two formula fields and then combining the two values into another formula field will circumvent the problem, right? Wrong. You are getting this error because SFDC counts every character used to create source fields for a formula. There are two approaches to take: (1) shortening API Names, and (2) using Workflow Filed Updates. Shortening API Names: You can try shortening API names, but this has not helped me much in the implementations that I have delivered. Workflow Field Updates: The best way around the limit is to use workflow field updates since: they do not have a compile limit, and; the compiled size that is reference
Quick tips and tutorials on Salesforce to help you develop on the platform. Some things you need to do "because Salesforce". #bcsf