How Do I Add Wiki Markup in Structure For Multiple Statuses?

[Glenn_Weissel]

Hello!

I want to add an expression in a formula column that looks at multiple Jira Statuses and returns a message based on the status and date.

This is the expression:

IF (Issuetype = "CHProject"):

IF (Status != "Open" or "In Definition"):

IF (CommittedDate < today(), "{color:red}OVERDUE{color}",

DAYS_BETWEEN(today(), CommittedDate) <= 1, "{color:red}Due in 1 Day{color}", DAYS_BETWEEN(today(), CommittedDate) <= 7, "{color:blue}Due Within 1 Week{color}", DAYS_BETWEEN(today(), CommittedDate) > 7, "{color:green}More Than 1 Week Out{color}", "{panel:bgColor=#f30202}Needs Committed Date{panel}")

While the above gives me what I want (the message) for the other statuses (In Progress, Tech Ready) the Open and In Definition statuses are getting a 'Needs Committed Date' msg in the corresponding rows. I want these rows to display nothing (blank).

What am I missing?

Thanks!

Glenn

[Glenn_Weissel]

Never mind. I removed the last expression after I published this question. The results are what I need.

[Dave Rosenlund _Trundl_]

Hi, @Glenn_Weissel. Welcome to the community 👋

Glad you were able to resolve this on your own. You may be interested in the following recorded video sessions on Structure Formulas.

Best,

-dave