Nested if in structure formula

[Els Vercauteren]

In a column in a structure a want to forsee a column with indication about story within the closed sprint 

I want to visualize 3 things

- incomplete stories in sprint

- removed stories from sprint

- added stories from sprint

So 3 if statements needed

- if jql {issuefunction in incompletesprint(19490,52740) and project in (iac) : "{color:red}(x){color}"

==> I want to combine 3 of those if but always get error

==> how can i do this with the 3 different issuefucntions incompletsprint, addedaftersprintstart and removedaftersprintstart

[Stepan Kholodov]

Hello @Els Vercauteren 

You can try this approach:

1. Save all 3 JQL queries with mentioned Scriptrunner's functions as filters and
2. Apply them in Formula columns with formulas like this: if jql{filter = "xxx"}: "..."

where "..." is the value you want to be returned in case of a match, and the coloring rule that should be applied to it. Depending on what hosting type you have, the column's format should either be Wiki markup for Data Center or Markdown for Cloud;. You can find more about how to expressions should be created in each format on our Wiki.

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

Best regards,
Stepan
Tempo (the Structure app vendor)

[Els Vercauteren]

and how do i put them then in formula . What between the if statements ? as that seems to be the issue.

i can not add all 3 at once

if jql {filter="150539"} : "{color:red}(x){color}"

if jql {filter="150538"} : "{color:green}(x){color}"

if jql {filter="150537"} : "{color:orange}(x){color}"

[Els Vercauteren]

@Stepan Kholodov  Hi Stepan, is this clear now or do you need something else ? 

[Els Vercauteren]

@Stepan Kholodov  Hi Stepan, clear now ?