As a Salesforce consultant, while working in Salesforce you will use various formulas for different operations like Date related formulas, etc. We have explained how to use Salesforce formulas in both Salesforce Lightning and Salesforce Classic. Do let us know if you have any problems using these formulas.
The MID() function in Salesforce returns a set number of characters from the middle of a text value, starting at a position you choose: MID(“Salesforce”, 6, 5) returns “force”. Combined with FIND(), it extracts text between two markers, such as the domain of an email address or the code after a “#”. Most MID tutorials … Read more >>>
I was assigned a task at work that required me to calculate the number of days between two dates in Salesforce. To fulfill this requirement, I created a formula field and used an advanced formula to display the number of days. In this Salesforce Tutorial, we will learn the formula to calculate the number of … Read more >>>
A sales manager wants to know when their team last contacted each customer. They need a field that displays the most recent activity, such as a call, meeting, or email, on the account. This helps them quickly find which customers have not been contacted recently and take follow-up action. I was assigned the task of … Read more >>>
I got a task at work that required me to calculate the difference between the date and time fields using Salesforce. To fulfill this requirement, I define an advanced formula. In this Salesforce Tutorial, we will learn how to calculate DateTime field difference in Salesforce. Additionally, we will review how to use Salesforce Lightning to … Read more >>>
A company wants to know the exact age of its customers based on the Date of Birth stored in Salesforce. Instead of calculating it manually every time, they want a formula field that will automatically show the customer’s age in years on the record. In this article, we will learn how to use the Salesforce formula … Read more >>>
While working for an organization that uses Salesforce, I was assigned the task of assigning the next available date to a client. To fulfill this requirement, I define an advanced formula that checks for null values in dates. In this Salesforce tutorial, I will demonstrate how to check for null values in dates within Salesforce. …