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

Josh Roberts_r8rgfm

Hello,

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}}""" :

Case(documentation.status,
"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. 

Stepan Kholodov

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
Tempo