Formula Fields

Salesforce Formulas

GPT writes formulas! You can give GPT a request for a formula and it will do it’s best to translate that into a functioning formula that you can paste into your Salesforce org. In the example below, our business requirement is to get a formula field on the opportunity to calculate a commission. It’s 10% of the opportunity amount plus 5% of any amount over $100,000. Watch how AI provides a perfect response!

Write a Salesforce formula for: 10% of Amount up to 100k and an additional 5% for any amount above.

AI’s Response:

Learning to get good formulas out of GPT is also a challenge. Again, your request is actually what determines the outcome. GPT is really good at formula structure too, so no mater how good or bad your request was, most of the time you’ll get good structure in your response so you can focus on the actual logic it returned instead of whether or not certain operators are used correctly!