Defining the formula syntax
A formula can be defined as a list of ingredients with which something is made, which is also a way to describe a recipe; and indeed, a formula is nothing more than a collection of values mixed together to get a resulting value that differs from the individual values put in. In mathematical terms, a formula is an algorithm that outputs a value based on other values, expressions, or fields.
In the previous chapter, we already saw a formula when defining the default value for a given custom field or when seeing the custom formula field type, which is one of the subjects of this chapter.
Let's create some examples of conditions that can be written with formulas:
If a case is related to an Account that is active and is open for more than 1 week, output a flagged checkbox named Urgent! (formula field).
Update the Stage field on the Opportunity object to Closed Lost if the opportunity is open for more than 2 months (the workflow rule&apos...
