Mastering the Magic: Unleashing the Power of Unique Salesforce Formulas

What are Salesforce Formulas?

Salesforce formulas are expressions or calculations that can be used to derive values, perform calculations, and manipulate data within Salesforce. They are primarily used to automate tasks, validate data, and generate dynamic content. Formulas can be applied to fields, workflows, validation rules, reports, flows, and more, enabling users to tailor Salesforce to meet their specific business needs.

Salesforce provides a wide range of formulas to handle various data manipulation and calculations. While it’s not feasible to list every single formula available in Salesforce, I can provide you with an extensive list of commonly used formulas across different categories. Here are some of the formula functions and operators available in Salesforce:

Text Formulas:

• BEGINS: Checks if a text field starts with a specified string.
• CONTAINS: Checks if a text field contains a specified string.
• FIND: Returns the starting position of a specified string within a text field.
• SUBSTITUTE: Replaces occurrences of a specified string within a text field with new text.
• UPPER: Converts a text field to uppercase.
• LOWER: Converts a text field to lowercase.
• TRIM: Removes leading and trailing spaces from a text field.
• TEXT: Converts a value to text.
• ASCII Returns the first character’s code point from the given string as a number.
• BR Inserts a line break in a string of text.
• CASESAFEID Converts a 15-character ID to a case-insensitive 18-character ID.
• FIND Returns the position of a string within a string of text represented as a number.
• GETSESSIONID Returns the user’s session ID.
• HTMLENCODE Encodes text and merge field values for use in HTML by replacing characters that are reserved in HTML, such as the greater-than sign (>), with HTML entity equivalents, such as >.
• HYPERLINK Creates a link to a URL specified that is linkable from the text specified.
• IMAGE Inserts an image with alternate text and height and width specifications.
• INCLUDES Determines if any value selected in a multi-select picklist field equals a text literal that you specify.
• INITCAP Returns the text as lowercase with the first character of each word in uppercase.
• ISPICKVAL Determines if the value of a picklist field is equal to a text literal that you specify.
• JSENCODE Encodes text and merge field values for use in JavaScript by inserting escape characters, such as a backslash (), before unsafe JavaScript characters, such as the apostrophe (‘).
• LEFT Returns the specified number of characters from the beginning of a text string.
• LEN Returns the number of characters in a specified text string.
• LPAD Inserts characters that you specify to the left-side of a text string.
• MID Returns the specified number of characters from the middle of a text string given the starting position.
• REVERSE Returns the characters of a source text string in reverse order.
• RIGHT Returns the specified number of characters from the end of a text string.
• RPAD Inserts characters that you specify to the right-side of a text string.
• VALUE Converts a text string to a number.

Numeric Formulas:

• ROUND: Rounds a number to a specified number of decimal places.
• FLOOR: Rounds a number down to the nearest whole number or specified decimal place.
• CEILING: Rounds a number up to the nearest whole number or specified decimal place.
• MAX: Returns the largest value from a set of numbers.
• MIN: Returns the smallest value from a set of numbers.
• ABS: Returns the absolute value of a number.
• SQRT: Returns the square root of a number.
• RAND: Generates a random number between 0 and 1.

Date and Time Formulas:

• TODAY: Returns the current date.
• NOW: Returns the current date and time.
• DATE: Creates a date using specified year, month, and day values.
• YEAR: Extracts the year from a date or date/time field.
• MONTH: Extracts the month from a date or date/time field.
• DAY: Extracts the day from a date or date/time field.
• HOUR: Extracts the hour from a date or date/time field.
• MINUTE: Extracts the minute from a date or date/time field.
• SECOND: Extracts the second from a date or date/time field.
• ADDMONTHS: Adds a specified number of months to a date or date/time field.
• ADDDAYS: Adds a specified number of days to a date or date/time field.
• ADDHOURS: Adds a specified number of hours to a date or date/time field.
• ADDMINUTES: Adds a specified number of minutes to a date or date/time field.
• ADDSECONDS: Adds a specified number of seconds to a date or date/time field.
• YEARFRAC: Calculates the fraction of a year between two dates.
• TIMENOW: Returns the current time.

Logical Formulas:

• IF: Evaluates a condition and returns a specified value if the condition is true, and another value if false.
• AND: Checks if all specified conditions are true.
• OR: Checks if at least one of the specified conditions is true.
• NOT: Reverses the logical value of a condition.
• ISNULL: Checks if a field is null (empty).
• ISBLANK: Checks if a field is empty or contains no data.
• ISPICKVAL: Compares the value of a picklist field with a specified value.
• ISNUMBER: Checks if a value is a number.

Advanced Formulas:

• CASE: Evaluates multiple conditions and returns different values based on the conditions met.
• HYPERLINK: Creates a clickable hyperlink using specified URL and display text.
• IMAGE: Inserts an image into a formula field.
• PRIORVALUE: Returns the previous value of a field.
• BLANKVALUE: Replaces a blank value with a specified default value.
• NULLVALUE: Replaces a null value with a specified default value.

String Formulas:

• LEN: Returns the number of characters in a text field.
• LEFT: Returns the specified number of characters from the beginning of a text field.
• RIGHT: Returns the specified number of characters from the end of a text field.
• MID: Returns a substring from a text field starting at a specified position and of a specified length.
• FIND: Returns the starting position of a specified string within a text field.
• ISPICKVAL: Compares the value of a picklist field with a specified value.
• CASESAFEID: Converts a 15-character Salesforce ID to a case-safe 18-character ID.

Mathematical Formulas:

• +, -, *, /: Basic arithmetic operators for addition, subtraction, multiplication, and division.
• ROUND: Rounds a number to a specified number of decimal places.
• FLOOR: Rounds a number down to the nearest whole number or specified decimal place.
• CEILING: Rounds a number up to the nearest whole number or specified decimal place.
• MOD: Returns the remainder after division of one number by another.
• ABS: Returns the absolute value of a number.

In this blog post, we will delve into the world of Salesforce formulas and explore their various categories and functions. For further learning, you can refer to the official Salesforce documentation available at link.