Use the latest date from mirror columns in formula

Hi,

I have formula that use latest date from mirror columns that use more than item connected.

2 weeks ago my formula show error and spot using the latest date . is something change?
Can I Use the latest date from mirror columns in formula?

Thans omer

Hello @omerpel !

If I understand correctly, the formula uses a mirror column that can be connected to more than one items?

If so, this may be where the problem is.

Please feel free to provide a little more context and / or screenshots so I can help more.

Best,
Giannis, Implementation Consultant at thespelas.com

Hi Omer,

I think you may find this post useful: Duration calculation for Timeline column summary - #6 by FrancisElliott

You can use Formula columns as a workaround to get the latest date from a Mirror column. as Giannis says, it is almost certainly due to multiple mirrored items (or perhaps multiple mirrored boards, in which case this solution may not work). Please share screenshots of the mirror column’s config in any case.

Solution

Here is the basic structure and the config for the mirror column. I have this set up with Subitems, however mirrors for other connect boards columns will also work.

(status column not important)

The formulas

Date #

``````FORMAT_DATE({Date},"YYYYMMDD")
``````

Latest Date #

``````SUBSTITUTE({Latest Date ⚙️},",","")
``````

Latest Date Formatted

``````CONCATENATE(
LEFT(
{🧪 Latest Date #},
4
),
"-",
RIGHT(
LEFT(
{🧪 Latest Date #},
6
),
2
),
"-",
RIGHT(
{🧪 Latest Date #},
2
)
)
``````

How It Works

Basically it converts the date to a number, uses the “Max” number (i.e. the latest date) and then converts that back into a usable date format (YYYY-MM-DD).

I definitely hope monday.com allows us to use values from mirrored date and timeline columns in formulas. I think this would be really simple to implement.

Hi,
Thanks alot. It work

1 Like