I’ve been a huge fan of Trailhead since its early days, and I’m a really big nerd about formulas. I believe that formulas are an admin’s true superpower. Simple ones are approachable for even the most beginner admin, but you can also solve complex business needs if you get a bit fancier. Want to know a contact’s next birthday so you can automatically send them a greeting? Want to prevent edits to a record only under certain circumstances? You can do all of these and more with some complex formulas!
Salesforce loves to invite involved community members to contribute to new projects and content, so when I got the chance to help craft a new Trailhead module to help admins level up their formula superpowers, of course I said YES! With several years of formula-building adventures under my belt, I got together with some other MVPs, community rockstars, and the Salesforce Docs team to brainstorm all our best practices and top tips.
We talked about our common (and not-so-common) uses for basic business logic and formula fields, tricks for making formula compile size shorter, how to approach doing complex math in formula fields, how best to apply formula knowledge to Validation Rules, how to use spacing and line breaks to make your formulas easier to read, and more.
We also had a great discussion sharing our most common formula blunders: battling with nested parentheses, mixing up Date and DateTime data types, dealing with leap years, parsing picklists, forgetting that final “else” argument in a CASE() function…nobody’s perfect! We all struggle to get to that magical green “No Syntax Errors” message some days!
The biggest debate? AND() vs &&, of course! (Team && all the way!)
This nerd-tastic meeting of the minds was the first step toward a new Trailhead badge for Advanced Formulas! Special thanks to Brian Trimboli from Salesforce Docs for writing an incredible module.
Here are my top three reasons you should go get this new badge RIGHT NOW:
How often do you get a request that you think could be solved by a formula, but it seems too complicated to tackle? Don’t give up! You’re an #AwesomeAdmin! You’re a superhero! Superheroes don’t back down! Level up your skills so you can confidently address complex business requirements with formulas.
Complex formulas are a great way to learn programmatic thinking without actually coding. Sussing out the logic behind a formula field or Validation Rule is exactly the kind of thinking developers use to write code. If this or this, then that, but if not, this other thing and this other thing. Being comfortable with these kind of statements is a great step toward understanding the basics of programmatic thinking you’ll need if you ever decide to tackle code. And even if you don’t ever tackle code, you’ll be more comfortable and confident talking to your Developer Friend. (You do have one, right?)
Have you seen some of the amazing formulas Steve Molis (SteveMo) comes up with on the Success Community? Steve has a true talent for taking business requirements and turning them into powerful, complex, elegant formulas. Now with the skills you’ll learn in this new Advanced Formulas badge, you’ll be able to write complex formulas too! Impress yourself! Slay those nested parentheses!
Check out the Advanced Formulas badge on Trailhead today!
In my role as Lead Admin Evangelist on the Admin Relations team, I have been dedicating my time to not only learning Agentforce but also building agents and creating demos for Awesome Admins to adopt Agentforce at their organizations. Through the process of building, testing, and refining, I’ve gained some valuable insights that all admins […]
Have you ever wished you could give your users exactly the right guidance at just the right moment? That’s the magic of Next Best Action! Whether it’s helping a sales rep spot the perfect opportunity for a follow-up or guiding a service agent with a recommended solution, Next Best Action allows you to create custom […]
As an Awesome Admin, it’s probably in your nature to look for any way to optimize a process or situation! As part of that never-ending desire for optimization, I would bet that you’ve spent a lot of time thinking about your permissions setup in Salesforce. Salesforce provides multiple ways to grant permissions to users, each […]
