New in Formulas 2.0
The lets()
function will allow you to assign values to multiple variables, and then use those variables in the expression.
lets(variable, value, variable, value, ..., expression)
variable.lets(value, variable, value, ..., expression)
Code language: JavaScript (javascript)
Note that the resulting variables can only be used between the brackets of the original lets()
function.