Jira Structure Formula based on labels

Emily Urbanski

I have an existing formula column to calculate a weighted score. Next, I would like to add on to those weighted scores based on label usage. My goal: if an issue has any one of the labels, it should add 10, but if it has multiple matching labels, it should add multiples of 10 (i.e. if an issue has both label1 and label2 applied, it should add 20 to the score).

IF CONTAINS(labels,"label1"): 
Weighted_Score = Weighted_Score + 10
IF CONTAINS(labels,"label2"): 
Weighted_Score = Weighted_Score + 10
IF CONTAINS(labels,"label3"): 
Weighted_Score = Weighted_Score + 10
IF CONTAINS(labels,"label4"): 
Weighted_Score = Weighted_Score + 10

The first line works, but when I add the others, I get an error. Thoughts? Ideas? Appreciate any help you can provide! 

David Niro

Hello @Emily Urbanski ,

I believe the reason for the error is that after the first IF function, it should be ELSE IF.  Something like

IF condition 1:
  value1
ELSE IF condition 2:
  value2
ELSE IF condition3...

However, based on the description of your goal, IF conditional statement probably will not return the desired results.  As soon as one of the conditions is met, it will stop.  So would not return the multiples, only ever 10.

What we will want to do here is something like this:

with value_search =
  ARRAY("label 1","label 2","label 3"):
with modifier =
  labels
   .FILTER(value_search.CONTAINS($)).SIZE():

weightedscore + (modifier*10)

First, we will create an ARRAY of all the labels you want considered (with value_search).

Next, we FILTER the labels field, returning only labels that are found (CONTAINS) in the value_search.  Instead of returning the list of values, we will reference the SIZE, which counts the number of labels that are left.

Lastly, we can take this count, multiply it by 10 and add it to the weighted score.

Please give it a try and let me know if it helps, or if you have any additional questions!

Best,
David