What is Mirror Magic: Numbers?

What is Mirror Magic: Numbers?

Mirror Magic: Numbers is a suite of automation templates which copies the summary of a number mirror column to another number, text, or mirror of number or text column.
  1. Supports mirrors of numbers columns.
  2. Supports mirrors of mirrors of numbers columns. 
  3. It is possible to chose a mirror of any type of mirror column, so chose a column you know mirrors a mirror of numbers. Mirrors of Formulas are not supported.
  4. Writes the summarized value to a numbers or text column, including mirrors of numbers or text.
  5. Only the first mirrored item is copied to at this time. Mirrors of mirrors are not supported for output.

Automation Templates

  1. "When button clicked copy sum of numbers mirror to target column"
  2. "When status changes to something copy sum of numbers mirror to target column"
  3. "When date arrives copy sum of numbers mirror to target column"
  4. "When column changes copy sum of numbers mirror to target column"
  5. Supports subitems when the selected trigger column is a subitem column
Mirror Magic: Numbers actions are not supported in the custom automation builder due to monday.com limitations.

Summary Functions

Summary functions are the method by which the number mirror column is summarized. Number mirrors have a default summary method of "sum" but you can change this in the mirror column settings. The recipe allows you to override the column setting, and create a summary using any of the supported methods.
  1. Sum - the sum of the mirrored numbers.
  2. Average - the average of the mirrored numbers.
  3. Median - the median (middle most) number of the mirrored numbers.
  4. Min - the lowest value of the mirrored numbers.
  5. Max - the greatest value of the mirrored numbers.
  6. Count - the count (how many) of the mirrored numbers.
  7. Count Positive - the count of how many numbers are positive.
  8. Count Negative - the count of how many numbers are negative.
  9. Count Zero - the count of how many numbers are 0.
  10. Sum Positive - the sum of all the positive numbers.
  11. Sum Negative - the sum of all the negative numbers.
  12. Average Positive - the average of all the positive numbers.
  13. Average Negative - the average of all the negative numbers.
  14. Mirror Summary - use the default summary method according to the column settings.
Blank numbers are ignored, they are not treated as 0s. This is consistent with monday.com's behavior.

    • Related Articles

    • 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 ...
    • What is Update Magic?

      Update Magic #1 is the ultimate UPDATES toolbox. A collection of powerful, easy-to-use recipes and automation action blocks that will give you the power to magically make your Mondays better! Use Cases: Remove ALL new updates (effectively, stops ...
    • 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 ...
    • Copy Columns

      Copy Columns is a Column Magic feature that can copy the value of one column to another, including mirror columns that mirror a single item. Multiple trigger types are provided for copying mirrors, special columns, or local columns - or the value of ...
    • Purchasing Monday Man Apps

      You can purchase our apps from the monday.com Marketplace. The Marketplace is a secure app store managed by monday.com. All transactions and details are processed by monday.com to keep your data secure. Apps in the Marketplace: Column Magic Update ...