Evaluate Subitem Expression to Column

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:
  1. {pulse.numbers}*{pulse.numbers9__1}

More details about expression operators and functions is provided in the main Evaluate Expression to Column article

    • 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 ...