Structure Formula column , is there an option to have more then 1 value when If Statement is True

Question

Hello!

In the IF statement below, i want to add also flag= "Red", when the condition is True:

with FORMAT_CAPTION(color, caption) = (
""":panel[$Caption]{backgroundColor=$color color=white}"""
):

with redChildren = COUNT#children{IF(flag = "Red", key)}:

IF status = "done":
FORMAT_CAPTION("#36c", ":sunny: **Completed**")

ELSE IF (level = 1 or level = 2) and redChildren > 0:
FORMAT_CAPTION("#d33", ":cloud_with_lightning_and_rain:   **At Risk   **")

Can i write:

FORMAT_CAPTION("#d33", ":cloud_with_lightning_and_rain:   **At Risk   **", flag="Red")

OR

FORMAT_CAPTION("#d33", ":cloud_with_lightning_and_rain:   **At Risk   **") and flag= "Red"

David Niro · Answer

Hello @Shira Hanan ,

Sorry, I am not understanding what the desired end result is.

Could you please reach out directly via support@almworks.com or support.almworks.com?

We can set up some time to review all of the specifics in more detail.

Look forward to hearing from you.

Best,
David

Shira Hanan · Answer

Thanks David, this is getting Really close to what I'm Trying to get!

the difference is , i want to set value (color)  into the Flag field (flag = "Green"/"Yellow"/"Red") and not present it in the caption, in order to use this color and calculate something for the Epic/Initiative above it (Parent).

for example:

IF status = "done":
FORMAT_CAPTION("#36c", ":sunny: **Completed**",flag = "Green")

gives me a massage with the text/Image and background but also a number (0/1) for the flag field, which I'm not interested of.

i guess the change should come here:

with FORMAT_CAPTION(color, caption, Flag) = (
""":panel[$Caption $Flag]{backgroundColor=$color color=white}"""
):

But i'm not sure how to change it exactly , can you help?

thanks!

Shira

adding the structure i'm using - https://obok.atlassian.net/plugins/servlet/ac/com.almworks.jira.structure/structure-widget#!s:688

David Niro · Answer

Hello @Shira Hanan ,

You are very welcome!  Thank you for the additional information.

Just to make sure I understood, the goal is to have the value from the Flag field included in the formula's return result?

If I have understood correctly, something like this should be close:

with FORMAT_CAPTION(color, caption, Flag) = (
""":panel[$Caption $Flag]{backgroundColor=$color color=white}"""
):

FORMAT_CAPTION("#59B161", ":sunny: **Awesome**",Flag)

I highlight the adjustments I made to the example formula from our Markdown in Formula Columns wiki document.

Essentially, Flag will need to be part of the Format_Caption local variable in order for it to be included in the Format_Caption references in the rest of the formula.

Also, you will need to map "Flag" to your custom field. It may not be recognized automatically.

Please let me know if this helps!

Best Regards,
David