Structure Formula to show Green when all requirements are marked In

Aditya Sastry

Hi,

I want to create a formula field and show "Pass" in green at feature level when all the requirements are marked as IN, "Pass" in yellow when some are marked IN and "Not Passed" in Red when all are marked OUT.

I have an IN/OUT checkbox field at requirement level.

My hierarchy is as below

Feature 1

Req 1

Req 2

Req 3

Req 4

Req 5

 

Feature 2

Req 1

Req 2

Below is how I would like to display in structure. Any help is appreciated.

 

Stepan Kholodov

Hello @Aditya Sastry 

You can try a formula like this:

if issuetype = "Feature":
with total_yes = sum#strict{field_name = "IN"}:
if total_yes = sum#strict{1}: "{color:green}Pass{color}" else
if total_yes = 0: "{color:red}Pass{color}" else
"{color:orange}Pass{color}"

The Format of the column should be set as Wiki Markup.

Best regards,
Stepan Kholodov
Tempo