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?


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


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: