Evaluate Expression to Column

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

Info
Use actions in the custom automation builder to support additional triggers, and trigger conditions! 
Idea
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. 
Info
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

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

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