Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Formula in Jira structure to check whether a specific component is present

I'm trying to create a custom column that calculates different values based on specific components.  I'm looking for a formula that will look at the component field and determine whether the component is present.  

I think Match should do it but I can't work out how to use it with a field.

 

Help will be greatly appriciated.

 

Zigi

1 answer

1 accepted

0 votes
Answer accepted

Hello Zigi,

Unfortunately, the Formula column is not implemented yet in Structure Cloud. If you would be interested, we can notify you when it is released in the future.

Best regards,
Stepan Kholodov
ALM Works

Hello Stepan, in which case I'm not using Jira cloud.   I can do formula's I just don't know how to do this specific one.

Can you help me with the actual formula?

 

Regards

 

Zigi

If you have the Server/Data Center version, then you can use this formula:
if(search("abc", components),1)
where abc is the name of the Component. As a result, the formula will mark with "1" all issues that have this Component.

I hope this helps. If you need further assistance with the Formula column or with something else, please feel free to contact us directly at support.almworks.com and we'll get back to you shortly.

Best regards,
Stepan Kholodov
ALM Works

Like # people like this

Thank you very much, that works. 


I tried unsuccessfully to extend the formula to search for two values thus:
if(search("abc" or  "def", components),1).

How would I do that?

 

Regareds

Zigi Fibert

I'm glad to hear it! If you want to add another Component, it should be wrapped in the search() function individually: if(search("abc", components) or search("def", components),1)

Best regards,
Stepan Kholodov
ALM Works

Thank you, Stepan.  Much appreciated.

 

Zigi

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,105 views 8 28
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you