Evaluate Subitem Expression to Column
Evaluate Expression is not a spreadsheet formula function, and does not use the syntax of monday.com formulas. It is meant for mathematical expressions.
Evaluates a MathJS expression and stores the result in the selected column. The trigger column should be one of your expression columns. (You may create multiple recipes to evaluate on multiple columns changing, but minimally trigger on the last column you will enter.)
The columns to store the result to are determined by the trigger column being a subitem column, or a parent item column. If you select a subitem column, you will store to a subitem column.
There is another Evaluate Expression action / automation template which does not support subitems, but has simpler expression creation.
Function Details
To support subitems, it is not possible due to monday.com limitations to use an input box that provides the selection of columns to use in the expression. You will need to manually enter the columns such as {pulse.numbers1}. The "numbers1" in the example is the column ID which you will need to obtain using the method describe in the monday.com documentation.
Here is a more complete example:
- {pulse.numbers}*{pulse.numbers9__1}
More details about expression operators and functions is provided in the main Evaluate Expression to Column article