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!


STRUCTURES: Color code using Formula column and an If Then scenario

Josh Roberts
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!
Nov 03, 2023


I am trying to write a formula for Structures that will display the Status of the issue, color-coded to a yellow background, but only under specific circumstances. 

I need the field to display as blank in all cases, unless the issue Status is set to "Done" and the Documentation Status (this is a custom field) is empty. 

Currently, I have: 


if (status.category = "done" and documentation.status = "null", "empty",

WITH format(text, color) = """:panel[${text}]{backgroundColor=${color}}""" :

"null", "empty", format(status, "#FFFF00")))


This is resulting in the column displaying the status of the issue color-coded to a yellow background (fantastic!), but it is displaying for every issue, not exclusively the ones that also have a blank value for Documentation Status. 


FWIW, I am using the Markdown format. 

1 answer

1 accepted

0 votes
Answer accepted
Stepan Kholodov _Tempo_
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.
Nov 06, 2023

Hello @Josh Roberts 

If you want to display the Status of issue on the yellow background if it's in the 'Done' category and it has no value in the Documentations Status custom field, then you can try this formula:

WITH format(text, color) = """:panel[${text}]{backgroundColor=${color}}""" :
if status.category = "done" and !documentationstatus:
format(status, "#FFFF00")

I hope this helps. If you need further assistance or help with anything else, please reach out to us directly at our support portal.

Best regards,
Stepan Kholodov

Suggest an answer

Log in or Sign up to answer