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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,556,712
Community Members
 
Community Events
184
Community Groups

How to write a formula to highlight current sprint tickets

1. I have a structure which has feature and user stories both are linked as parent-child

2. How do I write a formula in structure to highlight only stories of current sprint in some particular color.?

1 answer

0 votes
David Niro _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 16, 2023

Hi @Parveen Taj ,

For this, you will want to take advantage of the Item Properties for Sprint and the FILTER() or LAST() function to identify the Sprint you want to highlight.  Then, Markdown can be used to add the color to the returned value.

A quick example that you can use as a reference would be something like this:

IF issuetype = "Story":

""":panel[${sprint.LAST()}]{backgroundColor=yellow}"""

Hope this helps!

Best,
David

Unfortunately the above query is not helping.

I tried this and it works

IF ( Sprint = Sprint.LAST(),

" {panel : bgColor=#ADFF2F}CurrentSprint{panel}")

 

But still there is one problem, sprint.LAST() is not the one I am looking for I want to highlight only Current sprint tickets, how do I find what other methods are supported in Sprint variable for example  Sprint. Current  or sprint.active ? 

David Niro _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 17, 2023

Hi @Parveen Taj ,

That's interesting.  In your structure, do you see a button at the top that says "show generators" or do you see an option for "automation"?

Glad that you were able to get to a working formula.

Sounds like you will want to use FILTER() rather than LAST().  It should look something like this:

sprint.FILTER($.state = "Active")

Hope this helps!

Best,
David

At the top I see the button "Automation".

 

Yes, the above filter works, but it is applied to feature as well how do I exclude it , I tried below query but it does not work

 

IF( Sprint = Sprint.FILTER($.state = "Active") and issuetype != "Feature" )

I just got it .. I was doing something wrong at the braces.

 

Here is the query which Solved this problem.

 

IF (Sprint = Sprint.FILTER($.state= "Active") and (issuetype = "story"),

 

"{panel :bgColor=#ADFF2F}CurrentSprint{panel}")

David Niro _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 17, 2023

@Parveen Taj , glad it's working for you now!

for context on why the original formula wasn't working for you, there are some differences between Cloud and Onprem formulas.  The original formula I provided was written with Cloud in mind, but if you see "Automation", you are actually on an Onprem hosted instance.

Best,
David

Thanks for the clarification... Just one more thing, for now only the particular cell is in some color,  is there a way I can apply the color to  the entire row ?

David Niro _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 17, 2023

Hi @Parveen Taj ,

No, there is not a way to apply the color to the entire row.  For visibility, you could move the column in front of the summary so it's one of the first things to catch someone's eye.

In the above query it will not highlight the tickets if it is carried from last sprint to Current.

Is there a way if I can use contains 

IF( Sprint ~ Sprint.FILTER($state="Active" ))

OR

IF ( Sprint contains Sprint.FILTER($state="Active"))

David Niro _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 23, 2023

Hello @Parveen Taj ,

In your formula, instead of Sprint = Sprint.FILTER($.state = "active"), try:

Sprint.FILTER($.state= "Active")!= undefined

Best,
David

No this is not working

IF(Sprint = Sprint.FILTER(($.state = "Active")!=undefined) and (issuetype = "story"),

"{panel:bgColor=#ADFF2F}CurrentSprint{panel}")

1. Now my current sprint is "sprint4 "

2. There are couple of tickets carried from "sprint 3" to "sprint 5" even these panels are highlighted in color  , which should not be..

3. I have some tickets already created specific to "sprint 5" even these panels are highlighted in color , which should not be..

Suggest an answer

Log in or Sign up to answer