Q & A with Matt K! Solving a Scoring Formula Fail

Posted on February 29, 2024  (Last modified on May 15, 2025) • 1 min read • 170 words

We’re back with another installment of our series: “Q & A with Matt K!”..

We’re back with another installment of our series: “Q & A with Matt K!”. In this series, Matt sits down weekly to tackle Salesforce questions from the community — unrehearsed and unedited to demonstrate what it looks like when we encounter, evaluate, troubleshoot, and resolve real-world issues and use-cases. This time, in the #Formulas group, a Trailblazer asked how to craft a formula for calculating a score based on the values of two fields on a record. They shared their (lengthy) initial endeavor, and Matt walks us through both the solution, and some refactoring to make the formula even more efficient!

Give it a watch! Or jump to the question here on the Trailblazer Community for the answer! And if you’ve got a question you’d like Matt to answer, leave it in the comments here so we can add it to a future video or click this link and fill out our Q&A form! Until next time, keep working hard, smart, and happy. And we’ll see you in the cloud!