Evaluate Subitem Expression to Column

Evaluate Subitem Expression to Column

Warning
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.)


Info
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.
Alert
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 ...

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

    • Clear a Mirror Column

      Clears the columns mirrored by a mirror column across all items. monday.com has a limit on the number of items that can be changed per minute by an app. Beware that if you have many connected items, it will fail to clear all items - and negatively ...

    • About Column Magic

      Column Magic is a collection of automation templates and custom automation actions which will enable you to achieve workflows that are impossible with out it's magic. It is divided into four app features. Main Automations The Main feature provides ...

    • Expand Team to People Column

      Expands all individual team members into a people column. Use actions in the custom automation builder to support additional triggers, and trigger conditions! Function Details Can expand multiple teams from the same column Can be used to expand teams ...