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 _Tempo_]

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)

[Carlos fernandez muñoz]

Hi Stepan, many thanks for the answer. Somehow script is not working for me, just get the text  " :panel[32.01] {color=red}" instead of total SP in red.

tried to reach your support portal, but got stuck with the google account. Is it possible for you to check the script and paste here the fixed one?

many thanks in advance.

[Stepan Kholodov _Tempo_]

@Carlos fernandez muñoz 

The shared formula is correct. To display the values properly, you need to change the column's format to Markdown (you probably have it as General right now).

Best regards,
Stepan