How to clean up a custom field

Seth Mason
Contributor
November 15, 2022

I have a custom field with about 50 values that I'd like to export to .csv/excel to review with other stakeholderes for correctness.

How can I export this list of values?

2 answers

1 vote
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 21, 2022

Hi @Seth Mason the only way I can think of right now is to go to Filters > advanced issue search, add the column for the field you want to get all values from, search for all ideas in the project, then export to Excel/Sheets and from there use the UNIQUE() formula on the column to get unique values. 

It's only going to show you the values that have been assigned to ideas though

0 votes
Christel Gray
Contributor
November 15, 2022

Hi Seth - is this field pre-filled in (e.g., drop-down menu with choices, radio boxes, etc.) or is it a text field that users fill in?

Seth Mason
Contributor
November 15, 2022

Drop-Down with choices, they can select one or more options.

Like Christel Gray likes this
Christel Gray
Contributor
November 15, 2022

As far as I know, there's no built in way. Someone may have a script or Powershell way to do this. 

The way I'd do it (assuming you're in Jira Product Discovery) is to hover your cursor over the column you need the data from, click the ellipses (3 dots that appear) in that column, click "Edit field," then either highlight the text and copy it to an Excel or Word file or grab a screenshot of it.

edit product discovery field.png

I wish I had a better answer for you. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events