Format cell with multiple dates

[pKay]

Hi,

I have a formula that shows the end & start dates of a task based on the sprint start & sprint end dates.

However, there are cases where an item carries over and is completed in multiple sprints. In such cases, I want the formula to only show me the date based on the latest sprint.

Example:


Story above was carried over so was completed in two sprints. 

Here is my formula for the showing the Start date of a story based on sprint start date:

if issuetype != "Epic" : Sprint.StartDate

In this case, because the issue exists in two sprints the formula returns the values for both (as shown in attached image) which are dates 26/09/24 & 04/12/24.

I'm only interested in showing the latest sprint dates (04/12/24 in the case above).

How can I change my formula so that in cases where there are multiple dates being pulled, to only show the latest?

Thank you. 

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @pKay 

You can return the latest date with a formula like this:

if issuetype != "Epic" : Sprint.StartDate.max()

I hope this helps. If you need further assistance with the formula or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[pKay]

Amazing - thank you!

[pKay]

I will sign up to the portal as I'm a brand new Structures user. 

I'd like to ask if there is any documentation on how formulas work in Structures?
I want to learn some of the syntax and understand how it all works. 

Thanks again. 

[Stepan Kholodov _Tempo_]

Sure thing, you can check out our Wiki, find recordings of our Formula webinars and bootcamps on YouTube, and if you need help with any specific formula - please don't hesitate to contact us.

Best regards,
Stepan