...
Change the number of issues per page.
Status colour Green title new
...
Search
Input a keyword then press Enter (Return for Mac) on your keyboard.
...
Freeze or unfreeze columns
Hide or display columns
Create customized column configuration
...
Freeze/unfreeze or Hide/display columns
...
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.
...
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.
Data type | Support | ||||||
|---|---|---|---|---|---|---|---|
Text |
| ||||||
Number |
| ||||||
Date |
| ||||||
Date time |
| ||||||
User |
| ||||||
Label |
| ||||||
Component |
| ||||||
Status |
| ||||||
Radio |
| ||||||
Checkbox |
| ||||||
Single select list |
| ||||||
Multiple select list |
|
...
...
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
Components
Creator
Due Date
Issue Type
Project
Priority
Reporter
Sprint
Status
...
Smart Filter
Coming
...
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.
Click the lock icon to share the smart filter to any logged-in users in your Jira. Smart filter that is shared with other users will show a globe icon.
...
...
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.
...
After selected the desired number of issues, click the ‘Add’ button. A dialog will appear advising users to display the required field on the column if it does not exist in the spreadsheet.
...
In this example, we added 5 new rows. Selecting the project will change the value of the issue type.
...
...
Smart Filter
| Status | ||||
|---|---|---|---|---|
|
...
Find and Replace
| Status | ||||
|---|---|---|---|---|
|