Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Salesforce Formulas
Introduction
Introduction (0:34)
Developer Edition Signup (0:54)
What is a formula? (1:15)
What makes up a formula? (1:41)
Formula Data Types (2:06)
Formula Operators
Math Operators (1:07)
Logical Operators (1:38)
Text Operators (1:07)
Operators Quiz
Build our first formulas
First formula_ Average employee revenue (4:36)
First Validation Rule (6:45)
Tweak the validation rule - AND vs OR (2:05)
Logical Functions
Intro to functions (3:03)
IF (5:42)
AND and IF (6:14)
AND and OR comparison (3:12)
AND and IF Overdue part 2 (4:08)
Default Fields and CASE (8:52)
Better Salesforce Formula editor (2:28)
Nested IF statements vs CASE - Opp Discount (10:01)
Nested IF vs CASE - Close Date Month pt1 (3:22)
Nested IF vs CASE - Close Date Month pt2 (2:55)
INCLUDES and Multiple IF Statements (6:02)
ISBLANK and NOT (6:23)
ISNEW() - Flow (3:32)
Date and Time Functions
Common Date and Time Functions 1_2 (2:26)
Days to Opportunity Close (3:00)
Case Open duration (3:00)
Common Date and Time Functions 2_2 (1:10)
Different Date formats (5:46)
Date with Month written out (2:47)
Group report by day of week - WEEKDAY and CASE (6:26)
Date and Time Quiz
Math Functions
Common Math Functions (1:07)
MIN and MAX (6:04)
FLOOR and CEILING (2:06)
UNIXTIMESTAMP (3:07)
FROMUNIXTIME (3:56)
Text Functions
Text Functions pt 1 (1:20)
Begins 1_2 (1:50)
Begins 2_2 (4:16)
CONTAINS() (3:54)
CASESAFEID(Id) (2:25)
Text Functions 2 (0:55)
INITCAP, LOWER, UPPER, LEN (6:54)
LEFT and RIGHT (5:40)
LPAD (5:14)
Text functions 3 (0:48)
TRIM() (2:37)
SUBSTITUTE (3:20)
Substitute(substitute( (1:53)
Trim vs Substitute (1:43)
ISPICKVAL (3:34)
Text Functions Quic
Advanced Functions
Common Advanced Functions (0:53)
ISCHANGED (3:37)
REGEX 1_ Aus or US Postal Code (6:48)
REGEX 2- Salesforce syntax (1:54)
REGEX 3_ 5 or 9 digit postal code (2:55)
REGEX 4_ it's making field _required_ (2:08)
REGEX 5_ SSN and Aadhar (2:01)
Summary Functions - Reports
Summary Functions - Reports (0:59)
PARENTGROUPVAL - Accounts by Industry (4:51)
PARENTGROUPVAL - Percentage of Open Opportunities by Stage (3:46)
PREVGROUPVAL - Difference in Closed Won Amount by Month (5:40)
PREVGROUPVAL - Max Commission Difference over time (4:29)
Percent won or lost Opportunities (7:29)
Date with Month written out
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock