As you may know by now, Salesforce has an Idea Exchange category for upcoming Summer ’07 features. There are a lot of great features to be excited about including improvements to Mass Email, Workflow and Reporting. However, for me, the most exciting/useful feature will be the Cross-Object Formulas. Salesforce product management added a note to that idea saying that:
This idea really encompasses two features – referencing parent fields on a child, and rolling up child information to a parent. The latter of these is on schedule to be available with the Summer ’07 release! Stay tuned for more information in the coming months!
The ability to create formulas that COUNT, SUM, MIN, MAX, etc. values from child records will be huge. It will especially huge if conditions can be added within that. For example, from an Account, you might have a formula field to
SUM(all Won Opporortunities from a particular Lead Source). Another might be to simply
SUM(all Won Opportunities).
Until the release notes are out, we won’t know exactly what this functionality will (not) do, but it’s exciting to know some aspect of it is coming. This will save users a lot of time from having to run reports to get this information and it will save developers a lot of time having to create those reports!