...
...
...
...
...
...
Operation Bar Menu
...
Actions you can do from the operation bar:
Search a keyword.
Change to hierarchy view.
Expand or collapse the hierarchy viewEnable hierarchy mode.
Change the number of records issues per page.
Open column configuration
Enable sum-up row.
Apply conditional formatting
Group issues by field
Apply smart filter
Refresh page
Bulk create issues
...
Search
Input a keyword then press Enter -key(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.
...
| Info |
|---|
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
Field | Sum up Action |
|---|---|
Number | Sum |
Time Tracking Field | Sum and support Time Tracking format |
Date, Time | Show Min - Max  |
Selection Object
| Count the unique values |
Checkbox | Count the unique values |
Status | Total status grouped by status category  |
Resolution | Percentage of resolved issues. Resolved refers to resolution field with a value.  |
Sprint | Total of sprints grouped by sprint status  |
Configuration Menu
You can perform the below actions from the configuration menu:
Open column configuration.
Change number and Timetracking field format.
Export to Excel/CSV.
Get support.
Open documentation.
Leave feedback.
etc.
Export Excel / CSV
Users can export the current spreadsheet in Excel or CSV format.
...
Other functions
Excel-like Issue Editor provides the other functions via the cog icon menu.
...
Databar Number
Visualize the number field’s value.
...
Format Timetracking Fields
Change the display format of time-tracking fields.
Unformatted ↔︎ Formatted
...
...
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.
...
Refresh
Refreshing data will ensure you are updating the latest information.
...
...
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.
...