🎥 LIVE CLASS 15, 🧠 Recap: Formula Fields Masterclass (Beginner Session)

🧠 Recap: Formula Fields Masterclass (Beginner Session)

Session Focus: Understanding and applying basic formula fields in Salesforce

✨ What We Covered:

In our last session, we began exploring Formula Fields—a powerful tool in Salesforce that lets us calculate values dynamically based on other fields. You learned how to create formula fields with different output types and write formulas that solve real business problems.

Here’s a summary of the formula types and examples we built together:

1. Date Formula Field – Display Today’s Date

✅ Goal: Create a formula field that shows the current date.

✅ Formula:

TODAY()

✅ Use Case: Helpful when you want to display the current date or calculate differences between dates.

2. Text Formula – Combine First Name and Last Name

✅ Goal: Display the full name of a Contact or User in one field.

✅ Formula:

FirstName & " " & LastName

✅ Explanation:

We used the & symbol to concatenate the two fields with a space in between.

3. Currency Formula – Calculate Total Price

✅ Goal: Multiply Quantity by Unit Price to get Total Price.

✅ Formula:

Quantity__c * Unit_Price__c

✅ Use Case: This is common in e-commerce, invoicing, or quote calculations.

4. Checkbox Formula – Check if Opportunity is Missing Info

✅ Goal: Return TRUE if required fields are missing (like Amount or Close Date).

✅ Formula:

ISBLANK(Amount) || ISBLANK(CloseDate)

✅ Use Case: Mark a checkbox if important data is missing. This can trigger other actions like validation or reporting.

5. Text Formula – Label Opportunity as High or Low Value

✅ Goal: Use IF condition to tag opportunities by value.

✅ Formula:

IF(Amount > 10000, "High Value Opportunity", "Low Value Opportunity")

✅ Explanation:

If Amount is greater than £10,000, label it as “High Value”; else, label it as “Low Value”.

💡 Bonus Tips:

Always match data types. If comparing a Date to a DateTime (like CreatedDate), use DATEVALUE().

Use ISBLANK(), AND(), OR(), and IF() often in formula fields.

Use & to join text fields and " " to include spaces.

Always test your formulas before activating!

Next Steps for You:

✅ Practice recreating each of the examples above in your own Dev Org.

✅ Try changing the values and conditions to see how formulas respond.

✅ Think of one new formula field relevant to your own use case and try building it!

📌 Watch the class recording here:

➡️ [Replay Link Here]

3 comments

Pathway To Salesforce (PTS)

skool.com/pathway-to-salesforce

A community to help you transition into tech, master Salesforce skills, and unlock career opportunities with hands-on learning and real-world support.

Leaderboard (30-day)

+249

+229

+150

+91

+78