CEILING() Function in Salesforce | Syntax, Examples, & Use Cases

CEILING() Function in Salesforce

As a Salesforce Admin, I created a Formula Field for a decimal value (for example, 7.3). I used the CEILING() function to ensure the result always rounds up to the next whole number (in this case, 8). In this article, we will learn about the CEILING() function in Salesforce and how to use it to calculate the rounded-up value of … Read more >>>

LPAD() Function in Salesforce[ Syntax, Examples & Use Cases]

How to use LPAD Function in Salesforce Classic

In Salesforce, sometimes a requirement is that a Text or Number field must always be stored in a fixed-length format. However, users do not always follow this rule while entering data. For example, there is a field called Account Number where users must enter a 6-digit number, but a user enters only 4154 (4 digits). To solve this problem, we … Read more >>>

REVERSE() Function in Salesforce [Syntax & Real Examples]

REVERSE Function in Salesforce

In a company, order numbers are stored in a format like ORD-458921. The manager wants to create a short tracking code using only the last three digits of the order number. However, Salesforce formulas cannot directly read text from right to left. To solve this, you can use the REVERSE() function. First, reverse the order … Read more >>>

TRIM() Function in Salesforce [Formula Syntax & Examples]

TRIM() Function in Salesforce

I saw that most of the time all the Salesforce developers face an error where the client enters inaccurate data that has lots of unnecessary spaces. Due to this, the user faces problems in searching, decision-making, inconsistent data entry, missed opportunities, etc. So, I decided to overcome this problem, I started searching and found that … Read more >>>

RIGHT() Function in Salesforce [Formula Syntax & Examples]

RIGHT() Function in Salesforce

While working as a Salesforce Administrator, I created a custom field to store the Account Number in the format ACC-IND-000123. Now, the sales team has requested a new field that displays only the last 6 digits (000123) of the account number for reporting and reference purposes. To meet this requirement, I created a formula field and … Read more >>>

INCLUDES() Function in Salesforce

INCLUDES() Function in Salesforce

While working as a Salesforce Admin, our client wanted to track customer interest in buying a product using a multi-select picklist field called Interested Products on the Lead object. The client wanted to check whether a lead selected Mobile from a list of options, such as Laptop, Mobile, and Accessories. Based on this condition, the … Read more >>>

ISPICKVAL() Function in Salesforce

How to use the ISPICKVAL Function in Salesforce

While working as a Salesforce admin, I got a requirement from our client. Basically, they wanted to ensure that users enter the resolution details before closing a customer’s case. Many users were directly changing the case status picklist to ‘closed’ without adding a resolution. To solve this, I used the ISPICKVAL() function in a validation … Read more >>>

LEN() Function in Salesforce | Calculate Length of Text

LEN() Function in Salesforce

The client wanted all mobile numbers entered in Salesforce to be exactly 10 digits. They need this validation to ensure accurate communication with their customers. Any number shorter or longer than 10 digits should trigger an error message and prevent the record from being saved. As a Salesforce Admin, I used the LEN() function in … Read more >>>

IMAGE() Function in Salesforce [Use Cases, Syntax & Examples]

How to add image in the formula field in Salesforce

While working as a Salesforce admin, recently, I got a client requirement to automatically display the company logo on the account record as soon as a new account is created or an updated account name. The client did not want users to upload logos manually. Instead, they wanted Salesforce to show the correct logo based … Read more >>>

Agentforce in Salesforce

DOWNLOAD FREE AGENTFORCE EBOOK

Start with AgentForce in Salesforce. Create your first agent and deploy to your Salesforce Org.

Salesforce flows complete guide

FREE SALESFORCE FLOW EBOOK

Learn how to work with flows in Salesforce with 5 different real time examples.