Structure : use FORMULA with script. Filter if a label is there within labels field

[Els Vercauteren]

Hi,

i am setting up an IF statement for flagging tickets in a column in a structure. 

If the labels field contains BLOCKED i need the word BLOCK in red.

This works BUT

- if only label BLOCKED is there ==> works

- if >1 label is there (including a BLOCKED) it does not work the IF statement

How can i solve this ? 

thanks for assist

Els

[Stepan Kholodov _ALM Works_ · Accepted solution]

Hello @Els Vercauteren 

Setting the labels=xxx condition will only work when there is only one Label in an issue indeed. Using search("blocked", labels) instead should help.

Please feel free to reach out directly at support.almworks.com if you need our assistance with anything else.

Best regards,
Stepan Kholodov
ALM Works

[Els Vercauteren]

When i adjust with Search it works ! Thx

[Els Vercauteren]

Extra question

Can i change the smiley to a icon green flag and the blocked to icon red flag ? 

And is an icon bomb also available ?

[Stepan Kholodov _ALM Works_]

You can find the list of built-in emojis at the text formatting notation help page (at the bottom of it). You can also use your own images and include them in the formula by their URLs if needed.

Best regards,
Stepan Kholodov
ALM Works

[Vikrant Yadav]

Hi @Els Vercauteren  You have to use match function for this :- 

https://wiki.almworks.com/display/structure050/Expr+Pattern+Matching

if(match(labels;"BLOCKED")

Similar Post :- https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Need-help-evaluating-Labels-column-in-Formula/qaq-p/1395516

Thanks

V.Y

[Els Vercauteren]

I adjusted it but it still gives the ELSE part for the example below :-(