Evaluate Subitem Expression to Column
![](https://static.zohocdn.com/zoho-desk-editor/static/images/caution.png)
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.)
![](https://support.themondayman.com/galleryDocuments/edbsn86c63b382028dd31e23a1d1f15b03cb8e1a7e0537124e57f648a8405f7c6994ef4697fde4d87d0dfad0a9b6b13d6f86e?inline=true)
![](https://static.zohocdn.com/zoho-desk-editor/static/images/info.png)
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.
![](https://static.zohocdn.com/zoho-desk-editor/static/images/exclamation.png)
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}
Related Articles
Related Articles
Evaluate 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. Use actions in the ...
Text Builder
Text Builder is a Column Magic feature that allows you to build the value of a column from the values of other columns. Supported Output Columns You are able to build and write a text pattern to the following column types: Item name Text Column Long ...
Write Text Pattern to Column / Name
Action ...write text pattern to column ...write text pattern to item name Templates When item created... When status changes to something... When column changes... When button clicked... Use actions in the custom automation builder to support ...
Write Text Patterns to Link
See Write Text Patterns to Column for the basic of using a Text Builder action. These advanced actions allow you to create Actions ...write URL Pattern and text pattern to link column Templates When button clicked... When status changes to ...
Column Magic Automations
Column Magic is a feature of automations that provides the individual automations in the app that are not part of a suite of templates. Automations Evaluate Expression to Column Push Date Keeping Time Set Date from Date using Number Expand Team to ...