Jira Structure: Search strings in all labels and display all that matches in the column

[Phillip Ino]

Hello,

I am looking to setup a formula in Jira Structures that will search for strings on the labels and print it in a new column.

Consider the labels below:

• home_123_B
• 123_B
• bldg_234_C
• 234_C
• store_345_A
• 345_A
• mall_456_G
• 456_G

I want to match the string "123_B", it should pick up both "home_123_B" and "123_B" from the labels then print "home" into the new column.

And I would also like to match 2 strings "234_C" and "456_G", it should pick up "bldg_234_C", "234_C", "mall_456_G", and "456_G" from the labels then it should print "bldg mall" into the new column.

Any suggestions?

[Stepan Kholodov _Tempo_]

Hello @Phillip Ino 

You can try this formula:

if labels.contains("123_B") or labels.contains("home_123_B"): "home" else

if labels.contains("234_C") or labels.contains("456_G") or labels.contains("bldg_234_C") or labels.contains("mall_456_G"): "bldg mall"

I hope this helps. If you need further assistance with the formula or if you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)