Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

Input a keyword then press Enter (Return for Mac) on your keyboard.

...

Users can view their issues’ (Epic - Story - Subtask) hierarchy in Hierarchy View mode.

...

In this mode, users can collapse and expand the hierarchy.

...

Info

Hierarchy view mode needs all issues to make a hierarchy tree, so view "All" mode will be switched automatically in hierarchy mode.

...

  • Freeze or unfreeze columns

  • Hide or display columns

...

Image Removed

  • Rename columns

  • Create customized column configuration

Freeze/unfreeze or Hide/display columns

...

Rename Columns

If the default column name is too long, you can rename it according to your needs.

...

Create customized column configuration

You can create multiple column configuration according to your requirements.

  • Lock icon means it is only available to you.

  • Globe icon means other users can use your setting.

...

If you want to create a column configuration and share with other users, you can select the ‘Create Custom Configuration’ and select ‘Public’.

...

...

Sum-Up Row

This feature allows users to get the sum or summary of their Jira fields' values. Users can open it by clicking the sum button on the operation bar.

...

Group by is a feature to group spreadsheet rows to the selected field. Currently, these fields are available in the Group by feature.

  • Assignee

  • Due Date

  • Project

  • Priority

  • Sprint

  • Sprint status

  • Status

  • Components

...

...

Smart Filter

Smart filters enable users to apply filters on top of the JQL in their spreadsheet. These filters provide a quick overview of the total number of issues, and clicking on them applies the smart filter to the main JQL query in the spreadsheet.

...

Using the refresh button helps users save lots of time to get the latest data in the current spreadsheet. If multiple users are working on the same spreadsheet, it is advisable to load the latest data before making any changes.

...

...

Create Multiple Issues

Our bulk create issues feature eliminates multiple steps when creating new issues in Jira. Users can leverage this feature to create multiple issues directly on the spreadsheet at once, streamlining the process and saving valuable time.

...

Data type

Support

Text

Status
colourGreen
titleSupported

Number

Status
colourGreen
titleSupported

Date

Status
colourGreen
titleSupported

Date time

Status
colourBlueRed
titleComing soonNot supported

User picker

Status
colourGreen
titleSupported

Label

Status
colourGreen
titleSupported

Component

Status
colourRed
titleNot supported

Status

Status
colourRed
titleNot supported

Radio

Status
colourRed
titleNot supported

Checkbox

Status
colourRed
titleNot supported

Single select list

Status
colourRed
titleNot supported

Multiple select list

Status
colourRed
titleNot supported

...

Once you’re satisfied with the changes, click the save button. After saving, you will no longer be able to use the undo and redo buttons.

...

...

Chart

You can create generate pie or bar chart of columns that you added on the spreadsheet.

...

If you click the chart, the spreadsheet will be filtered according to the selected value. In this example, we clicked HTML on the pie chart to look for issues with Labels ‘HTML’.

...