Formula and Mirror Columns which are numberic to behave like Number columns

Feature requests
, , ,
1

This covers a range of feature limitations. From what I’ve read in other posts it seems to be with limitations on the system architecture side (formula and mirrors reside on client servers or something like that).
But the bottom line is that mirror columns and formula outputs should behave exactly like their counterparts in either numeric (more urgent for me) or text columns and they currently do not.

One or two of the current limitations include:

  • no column total provided for mirror columns (column totals are provided for formula columns)
  • formula columns cant be used in pivot tables
  • mirror phone numbers (or emails) aren’t “active” on my Monday mobile app. Its a dead text.
2

Thanks Tania - this is a challenge for us as well. We need to mirror dates from a master board to many other boards and want to be able to use those dates as triggers for Status changes, notifications, formulas, etc. - but the mirrored dates are not seen as Date columns.

Having this functionality would be a tremendous lift in scalability.

3

Hey @jennbell @Tania - agreed, this is a bit of a gripe many of us have with monday mirror and formula columns. Please be aware there are some apps out there that can assist with casting these columns to standard monday columns that can be used in all automations and integrations.

Check out Column Magic, General Caster or Autoboost. All of these provide some of the functionality you are looking for.

Thanks!
Mark
Book a Support Session

4

I agree - mirror columns that emulate numbers should function as numbers columns, with the ability to sum. This would make so many of my boards more efficient and useful.

5

I’d love to have the ability to quickly do sums in the numbers column (the number column to behave like an excel field where I can quickly do sums; i.e =20000+4000 within the numbers column). Can I do that already?

6

Hi everyone,
I would like to create formulas from mirroring datas. For example : I would like to create a cumber of days beetween a date column and a mirroring date column.

1 Like
7

Could not agree more. If you can select what you want the formula to display for a summary it should at least work.

8

Agree with all of this. I would love mirrored number columns to have the ability to sum, and also for automations to be able to be built off of mirrored timeline columns (e.g. when ‘date’ approaches, move to ‘group’).

1 Like
9

True. I use european date and the mirror on the workdocs get its as american which is very tricky for our deliveries!