Column Magic

Column Magic is the ultimate columns 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!

Features

Available Features

Column Magic is your all-in-one column toolbox for Monday.com, packed with powerful recipes and automation blocks to simplify and speed up your workflow. From copying, clearing, and building column data to setting statuses, managing people columns, and automating file-triggered actions, it handles repetitive tasks with ease. Most features are available as ready-to-use recipes or custom automation steps—making your Mondays smarter and more efficient.

Demo

Schedule a Demo

Schedule a free demo and discover how Column Magic can streamline your workflows, reduce manual updates, and supercharge your boards—all with easy-to-use recipes and automation blocks.

In your Column Magic Demo:

Functions

The Functions

Column Magic is your all-in-one column toolbox for Monday.com, packed with powerful recipes and automation blocks to simplify and speed up your workflow. From copying, clearing, and building column data to setting statuses, managing people columns, and automating file-triggered actions, it handles repetitive tasks with ease. Most features are available as ready-to-use recipes or custom automation steps—making your Mondays smarter and more efficient.

Column magic

Copy Local Column [LOCAL COPY] (Copy)

Copies the value of one LOCAL (standard) column to another column, including to a mirror column.

Column magic

Copy Mirror Column [MIRROR COPY] (Copy)

Copies the value of a MIRROR column to another column, including to another mirror column.

Column magic

Copy Special Column [SPECIAL COPY] (Copy)

Copies the value of a special column to another column, including to a mirror column.

Column magic

Copy Trigger Column [TRIGGER COPY] (Copy)

Copies the value of the trigger column to another column, including to a mirror column.

Column magic

Clear Mirror [CLEAR MIRROR] (Main)

Clear any column that can be cleared including MIRROR columns.

Column magic

Build Text to Name [BUILD NAME] (Text Builder)

Creates text from combined text and column values and writes it to the item name.

Column magic

Build Text to Name [BUILD NAME DATE] (Text Builder)

Creates text from combined text and column values and writes it to the item name.

Column magic

Build Text to Column [BUILD COLUMN] (Text Builder)

Creates text from combined text and column values and writes it to the selected column.

Column magic

Build Text to Link [BUILD LINK] (Text Builder)

Creates hyperlink URL and text from combined text and column values and writes it to the selected link column.

Column magic

Simple math [MATH] (Main)

Performs a simple calculation with two number columns and stores the result.

Column magic

Better math [MATH] (Main)

Performs calculation with any number of number columns and stores the result.

Column magic

Set Status on Required Columns [STATUS REQUIRED] (Required)

Sets a status based the existence of values in required columns.

Column magic

Create Update for Required Columns [UPDATE REQUIRED] (Required)

Create an update based the existence of values in required columns.

Column magic

Push Date (keeping time) [PUSH DATE] (Main)

Push a date by some amount of time keeping the time component.

Column magic

Expand Team to People Column [EXPAND TEAM] (Main)

Expands all individual team members into a people column.

Column magic

Remove Copy, Re: & Fw: from Name [REMOVE COPY] (Main)

Removes the “(copy)” added to the item name when duplicates.

Column magic

Assign Acting User [ACTING USER] (Main)

Assigns the user that triggered an event to a people column.

Column magic

Copy Group Name [GROUP NAME] (Copy)

Copy item’s group name to a column, appending, prepending or overwriting.

Column magic

Copy Board Name [BOARD NAME] (Copy)

Copy item’s board name to a column, appending, prepending or overwriting.

Column magic

Set Status on File Activity (upload/delete) [FILES] (Main)

Sets a status column value according to the last activity in a file column.

Column magic

Find Words in Text [KEYWORDS] (Main)

Find specific word(s) in a Text Column and set status with results.

Column magic

Remove Words from Text [KEYWORDS] (Main)

Find specific word(s) in a Text Column and REMOVE all that are found.

Column magic

Approve [APPROVE] (Main)

Approves proposed value change by moving PROPOSED to LIVE, clearing PROPOSED and resetting the approval status.

Column magic

Deny [DENY] (Main)

Denys proposed value change by clearing PROPOSED and resetting the approval status.

Change Log

Column Magic Change Log

Schedule a free demo and discover how Column Magic can streamline your workflows, reduce manual updates, and supercharge your boards—all with easy-to-use recipes and automation blocks.

Change from Sparks to Ops & Reduce Cost

2023/10/18

Sparks were converted to Ops and many functions were reduced in cost.

Build Text to Link added

2023/2/4

Creates hyperlink URL and text from combined text and column values and writes it to the selected link column.

Push Date (keeping time) changed

2023/1/21
  • Pushing empty dates will now push from CURRENT date & time.
  • Sparks used reduced.

When the date to be pushed is empty, the CURRENT date & time will be used.

Sparks & Tiers Board Template added

2022/10/20

Now a board can be created with this template that will provide visibility and control of Monday Man Apps’ Sparks.

New Copy Special Columns recipes give access to Name and ID columns

2022/10/20

These recipes allow copying of the Item Name and Item ID columns to suitable columns.

Copy recipes can now copy to the Item Name

2022/10/20

Copy function now allow copying to the Item Name.

Copy & clear of Checkbox columns added

2022/10/20

These recipes allow copying and clearing of Checkbox columns.

Copy from Mirror and copy to column selections now show column type

2022/10/20

These recipes allow copying of the Item Name and Item ID columns to suitable columns.

Improved performance and error messaging in recipe column selections

2022/10/20

Enhanced performance and clearer error messages when selecting columns in recipes.

Mirrored Number columns are summarized when copied to another column

When copying from mirrored Number columns to another number column (mirror or local), the value that is copied is the summarized value using the summarization method specified for the mirror column.