Calculate the latest date from mirror columns

Hi everyone!

I have a low level board with two timelines (expected timeline and actual timeline) This low level board is a template created for each project.

On the high level board that’s connected to each project, I’d like to be able to calculate how many days between the latest date in the first timeline mirror column and the latest date in the second timeline mirror column.

Can anyone please tell me if this is possible or how to work around it?

Thanks so much!

Hey Shauna!

Charlotte here for the team! :wave: Happy to help out with this!

The mirrored version of the timeline column won’t allow you to select the end dates in a formula like you can using a regular timeline column so I would suggest adding two new timeline columns and manually adding the dates you see reflected in the mirror columns so you can use these columns in your formula.

Then, you can set up a formula like the following:

DAYS({Timeline 1#End},{Timeline 2#End})

Let me know your thoughts!