multiple rules on formula column JIRA structure

Carlos fernandez muñoz

Hi there, 

In my team I have created a column per team member to see what are the storypoints committed each PIPE (we are working in SAFe and my team has multiple roles). I can see Sp at subtask, story, feature, program, quarter.. levels, playing with the filters and using "sum over sub-items" asn Sp are only at subtask or story level.

the outcome is that I see how good or bad we plan according to capacity.

Next level is possibility to color the value of those SP. If my team member has a capacity of 20 SP, can I color the value in red if that value is over 20? 

additional difficulty is that values are at subtasks and stories as I said, but Im interested on values at quarter level, so value is not in any ticket but a sum of them.

 

Many thanks for your help!

 

Stepan Kholodov

Hello @Carlos fernandez muñoz 

It depends on the specifics of the hierarchy in your structure. Color can be added using the Formula column & Markdown with something like this:

if sum{storypoints} > "20": concat(":panel[", sum{storypoints}, "]{color=red}")

For the Formula to consider the right sum, there has to be a parent item of some sort that contains all of the issues from which the Story points should be aggregated. You can use a Flex Item for adding into it issues from a certain quarter, or use a Formula grouper to group issues by quarters based on their Create date's month.

I hope this helps. If you need further assistance 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)