Tip of the Week

Tip of the Week – 100 helpful Salesforce formulas to get you started


We here at CloudMyBiz love Salesforce formulas! They can do more than just sum up a few values or spit out an average. In the past, we’ve told you about using formula fields to display images and even calculate business days between two dates, but that doesn’t even start to tell the whole story. When I started using Salesforce, I remember pigeonholing formulas into the few basic examples I was used to in Excel, low-level programming algorithms, and the handful of examples I’d seen in this or that forum. I didn’t realize that formulas in Salesforce open up a whole world of possibilities! Let me give you a few examples.

Whether you’re using the Sales or Service Cloud, ensuring a good load balance with Assignment Rules is crucial. Without formulas, it can be tricky to handle. But using a basic Mod function, you can set up Round Robin assignments in just a few minutes. If your company likes to send birthday wishes to customers, it can be a challenge to identify who you’ve got coming up. A formula and a quick report or list view can show you who has a birthday in the current month. All this and 98 other ideas are waiting for you with Salesforce’s 100 Sample Formulas to Get You Started. Check it out and try your hand at one today!

-Jared and the Salesforce Guys

, , , , , ,


  1. Easy financial formulas for Salesforce -

    […] at CloudMyBiz, we’re big proponents of formula fields. We’ve shared with you hundreds of formulas that can do anything from formatting data for document merging, to figuring out the exact age of a […]

  2. Supercharge your assignments with Round Robin Lead Assignment -

    […] for a while, you’ve seen a couple solutions for making your Assignment Rules amazing tools using round robin or location based assignment. But what if you need something simpler, need something that easily […]

  3. Assignment Rules have never been easier with RRD for Salesforce -

    […] lot of ways to assign records, and it can be a challenge to get a solid method in place. There’s formulas, creative solutions, and even a couple apps available, and I’d like to present to you this new […]

Leave a Reply