How do I use a wiki markup formula to indicate if a specific field has multiple entries.

Marc Formisano

For example, if there is a field called "worked iterations" and the value is either empty or has values that show up in the same column separated by commas I would like to indicate 1 value as GREEN, 2 values as ORANGE and 3 or more values as RED.  An example of "worked iterations" with 3 values is:  2023-1 Dec 7 - Feb 28, 2023-2 Mar 1 - Apr 25, 2023-3 Apr 26 - Jun 20

Darryl Lee

Hi @Marc Formisano so you're talking about wiki markup so you're probably talking about a custom field of type Text Field (multi-line).

So I think you're saying that in this table in your "worked iterations" field:

||heading 1||heading 2||dates|| |row A|col A2|<span>2023-1 Dec 7 - Feb 28</span>|<br>|row B|col C2|2023-2 Mar 1 - Apr 25, 2023-3 Apr 26 - Jun 2| |row C|col C2|2023-1 Dec 7 - Feb 28, 2023-2 Mar 1 - Apr 25, 2023-3 Apr 26 - Jun 2|

You would want the last cell in row A to be green, row B to be orange, and row C to be Red?

HUH, that's interesting. AFAIK Jira's text formatting does not allow for any conditional formulas.

I googled for: wiki markup conditional jira

The only thing that seems relevant (but also massive overkill) seems to be Structure:

• Excel-like formulas and conditional formatting in Jira? Yes, you can! Here’s how 

OH, I thought of a pretty gnarly hack using Automation for Jira:

You could parse that field after creation (or maybe also whenever it gets edited), using the match operator using a regular expression like "\d{4}-\d \w{3} \d+ - \w{3} \d+" and then get the size of the list returned, and then make that part of a condition to add {color:red} tags around the text. And this would all have to be used in conjunction with replace or replaceAll. Hum, I just don't know.

I think another problem is this that would only work if the table had ONE row, because ... I don't think there's a way to iterate over multiple lines.

Any thoughts, @Bill Sheboy ?