I'm trying to create a column in a structure that joins the summaries of each issue in an epic based on the sprint each issue is in. For example, I want a comma separated list of all the issues in "Sprint 1". I see how to use an aggregation function to do this for all the issues, but can't figure out if there is a way to aggregate based on a conditional statement.
Hi Todd,
You can aggregate things conditionally, so the formula you are looking for is probably:
JOIN#subtree{IF(sprint="Sprint 1", summary)}
Note that it works if only one sprint at a time is assigned. If issue is a part of several sprints you'd have to use IF(SEARCH("Sprint 1", sprint), summary)
Please, let me know if this helps.
Regards,
Egor Tasa
ALM Works
Thanks so much. This works. In the documentation it uses semi-colons between arguments in the IF function. Are commas and semi-colons interchangable?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, you can use either comma or semicolon.
Regards,
Egor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.