Skip to main content
Skip table of contents

Operation Bar Menu

Actions you can do from the operation bar:

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

Hierarchy View

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

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

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

Grid view

You can change the number of issues per page as below

Column Configuration

From here, you can:

  • Freeze or unfreeze columns

  • Hide or display columns

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.

Sum-up row's behavior


Sum up Action



Time Tracking Field

Sum and support Time Tracking format

Date, Time

Show Min - Max

Selection Object

  • Assignee

  • Reporter

  • Priority

  • User picker

  • Sprint

  • Version

  • etc.

Count the unique values


Count the unique values


Total status grouped by status category


Percentage of resolved issues. Resolved refers to resolution field with a value.


Total of sprints grouped by sprint status

Conditional Formatting

Conditional formatting allows users to set specific conditions to reformat the color of cells in their spreadsheet. This feature enhances visibility for users when they are searching for specific information.

Group By

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.

Bulk Create 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.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.