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

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


1 badge earned


Participate in fun challenges

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


Gift kudos to your peers

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


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!


Is it possible to change a card's colour by automation?

Mike Wilkins
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Oct 19, 2023

I would like to change a card's colour if a field changes as follows

sprint <> planned sprint

so if the item's sprint changes from that it was originally planned for, then the colour of the ticket will change

I don't think JQL allows you to set a cards colour in the board config by comparing two fields e.g. Desired for Delivery in Sprint / Iteration No <> Planned for Delivery in Sprint / Iteration No


1 answer

1 accepted

1 vote
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 20, 2023

Hi @Mike Wilkins -- Welcome to the Atlassian Community!

Where are you getting information about the "planned sprint"?  Is that a custom field your team has added?

Next, you are correct that JQL cannot compare issue fields.  (It is not a SQL, and so does not have such features.)

If you have any marketplace addons for JQL, they may support such comparisons. 

If you do not have such addons, a work-around could be to use an automation rule to detect the condition for the sprint mismatch, and then set a field on the issue which can be used in JQL to set issue color views.  For example, add a label (or custom field) and check for that with your card color JQL in the board settings.

Kind regards,

Mike Wilkins
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Oct 22, 2023

Thanks @Bill Sheboy I should have mentioned that they are custom fields. Your answer confirms my conclusion. However I have now been able to devise a (complex) JQL in the board configuration that meets the request.

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events