The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Basic Math operations in custom formulas ?

TP
Contributor
July 4, 2023

I am trying to get an idea of the number of sprints I'll have to spend on a feature based on person-days estimates of several teams.

I want to approximate this value by taking the biggest number of sprints that each team will have to spend on it

 

Team 1 30 person-days = 3 Sprints

Team 2 20 person-days = 1 Sprint

Team 3 60 person-days = 2 Sprints

I would like the result to be 3 Sprints and the way you would calculate it is 

Max(Sprints Team 1, Sprints Team 2, Sprints Team 3)

 

Is this planned in the near future ? I have to export into excel to do this which I would like to get rid of...

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
July 5, 2023

Hi @TP 

Are all of the fields you note in your Jira Product Discovery (JPD) project?  If so, it does not appear there is a max() function for custom formulas in fields yet.

Have you considered using an automation rule in your project to set the field?

Kind regards,
Bill

TAGS
AUG Leaders

Atlassian Community Events