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)