Minimum "end date" in timelines

Hi Monday community!

Another question related to mirror columns but this time on a timeline column.

What I try to do is to find the minimum end dates of items linked to another item as illustrated below:

The only thing I succeed to display is the maximum end date using “show the latest”:
image

If I use “show the earliest” it will consider the minimum start date and not end date as expected.

Is there a way to do that? I would like to avoid the split in 2 columns dates (start / end).

Thanks in advance! :slight_smile:

Hi @ECH - if you’re open to using apps, Smart Timeline + Duration might be helpful for your use case. It offers 20+ automation options that can make managing your dates and timelines a lot easier. Feel free to check it out, and I’m here if you have any questions or need a hand.

Hi Avo. Thanks for your proposal and for the time to answer me but marketplace is blocked by my company.