Evaluate Expression to Column

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 custom automation builder to support additional triggers, and trigger conditions! 
To evaluate expressions on subitems use the special automation template for subitem expressions

Operators

  1. + (addition) - 2 + 2 = 4
  2. - (subtraction) - 5 - 3 = 2
  3. * (multiplication) - 2 * 3 = 6
  4. / (division) - 6 / 2 = 3
  5. ! (factorial) - 5! = 120
  6. ^ (exponent) - 2^2 = 4
  7. % (modulus) - 5 % 3 = 2

Functions

  1. mean(a, b, ...) - calculates the mean (average) of the values.
  2. abs(x) - absolute value of x
  3. ceil(x, [n]) - round x toward plus infinity, with n (optional) decimal precision
  4. fix(x, [n]) - round x toward 0, with n (optional) decimal precision
  5. floor(x, [n]) - round x toward minus infinity, with n (optional) decimal precision
  6. lcm(a, b, ...) - least common multiple of a set of at least two values
  7. max(a, b, ...) - the maximum value of a set of at least two values
  8. min(a, b, ...) - the minimum value of a set of at least two values
  9. round(x, [n]) - rounds x toward nearest integer
  10. sign(x) - returns 1 for positive numbers, -1 for negative numbers and 0 for 0.
  11. sqrt(x) - square root of x
  12. add(a, b, ...) - sum a list of numbers
  13. gcd(a, b, ...) - greatest common denominator of a set of numbers.
  14. size([x])[1] - size of array of numbers in value x (used to get the count of values in a mirror of numbers column)

Mirror Columns

Mirrors of number columns are supported, however you must first if multiple items are connected use add(x) (sum), size([x])[1] (count), max(x), min(x), mean(x) (average) to get the value shown in the mirror column. However you could also use the mirror value in any function that accepts a set of numbers, such as lcm or gcd. 
The monday.com API returns a list of numbers separated by commas for mirrors of numbers columns, rather than convert this list to what is shown on the board we left it up to you - just in case you want to do something different than what the board does with it.


    • Related Articles

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

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

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

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

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