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

[Mike Wilkins]

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

[Bill Sheboy · Accepted solution]

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,
Bill

[Mike Wilkins]

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.