Jira Dropdown custom field type displays the menu item's id, not the value

I’m a little puzzled as to how to get the actual value out of my synced custom dropdown field from Jira - they’re displaying the menu item’s id number, as opposed to the value:

I’ve been attempting to parse this with a formula in another column, but I’m unsure of what data type that is - can anyone help me figure out how to get access to the value of “VALUE” in this column?

Hey there Keith! I suspect this is something we can help with. Can you try something like this as the formula?

Size.ParseJSON("#/Value")

Essentially you want to parse the JSON object being returned there and extract just the “Value” field.

3 Likes

This was definitely the solution I was hoping and looking for! Thank you so much!

(one minor change to make it work: it has to be lowercase:

Size.ParseJSON("#/value")

2 Likes