# JXL Cloud release notes
Feature change log of JXL for Jira Cloud.
# 2023
# 27 Jan 2023
More level visibility options
- Option to hide child and bottom level issues without parents
- Option to hide issues that are outside of levels
# 25 Jan 2023
Copy sheets between projects, more columns
- Copy sheets between projects
- Last viewed date column
- Smart column: Time since last viewed
# 19 Jan 2023
Enhanced conditional formatting
- Choose from 90 colours to format both foreground and background of cells and rows
# 12 Jan 2023
Smart column
- Smart column: All comments (when exported, all comments, their authors, times and dates are included)
# 2022
# 8 Dec 2022
More smart columns
- Smart column: Issue URL
- Smart column: Customer portal issue URL
- Smart column: Issue ID
- Smart column: Project key
- Smart column: Project ID
- Various smart columns related to comments
# 8 Nov 2022
More smart columns
- Smart column: Sprint status
- Smart column: Sprint closure
# 4 Nov 2022
Empty options in date and number column filtering
- Empty and not empty options in date and date time column filtering
- Empty and not empty options in number, time since, and time tracking column filtering
# 26 Oct 2022
More columns, time tracking format
- Category column
- Configurable display format in time tracking columns
# 18 Oct 2022
Views, sheet sharing
- Save frequently used states of features and preferences as views in sheets
- Share sheets with views enabled with other users
# 5 Sep 2022
More column sum-ups, more smart columns
- Sum-ups in "Time since..." columns with configurable sum-up style
- Various smart columns related to comments
# 31 Aug 2022
Merged columns
- Use merged columns to consolidate values from multiple individual fields from team-managed projects
# 16 Aug 2022
New issue structure preference
- Choose whether issues can be listed multiple times in the table across hierarchy levels in structures
# 11 Aug 2022
Insight custom field support
- Custom field type: Insight objects
# 9 Aug 2022
Images column
- Smart column: Images
# 4 Aug 2022
Conditional formatting
- Format background colour of cells and rows if field values meet specified conditions
# 14 Jul 2022
Column freezing
- Freeze columns on the left-hand side of the table
# 11 Jul 2022
Issue counts in groupings
- View issue counts in grouping rows
# 13 Jun 2022
Site migration
- Use the new migration feature to move your sheets between Jira sites
# 31 May 2022
Development information columns, smart columns
- Number of pull requests column
- Pull requests status column
- Number of builds column
- Builds status column
- Smart column: Number of labels
- Smart column: Number of components
- Smart column: Number of affected versions
- Smart column: Number of fix versions
- Smart column: Number of sub-tasks
- Smart column: Number of issue links
- Smart column: Number of issues linked
- Smart column: Number of attachments
- Smart column: Number of comments
# 23 May 2022
Sheet API, image file viewer, not empty in select column filtering, Deep Clone integration
- JXL Cloud API with create and delete sheet methods
- Insitu file viewer for image attachments
- NOT EMPTY option in select column filtering menus
- Deep Clone for Jira integration
# 11 May 2022
Issue Checklist for Jira columns, smart columns
- Issue Checklist for Jira Checklist column
- Issue Checklist for Jira Checklist completed column
- Issue Checklist for Jira Checklist progress column
- Issue Checklist for Jira Checklist progress % column
- Smart column: First commented by user
- Smart column: Last commented by user
# 4 May 2022
Issue security
- Security level column
# 2 May 2022
In-app help, column filtering improvements
- In-app help panel
- Select all action in column filtering menus
- Use EMPTY keyword with logical operators in text column filtering and table search
# 26 Apr 2022
Smart columns
- Project category column
- Smart column: Project type
- Smart column: Project configuration type
# 23 Mar 2022
Smart column
- Smart column: Time to due date
# 21 Mar 2022
Field sum-ups
- Sum up table contents
- Sum up groupings
- Add sum-up levels to custom issue structures
# 2 Mar 2022
Global permission, smart columns
- Manage who can make bulk changes to issues in sheets
- Smart column: Date of first comment
- Smart column: Date of last comment
# 23 Feb 2022
Smart columns
- Smart column: Time since status changed
- Smart column: Time between created and resolved
- Smart column: Last updated by user
- Smart column: Last update action
- Smart column: Number of sprints
- Smart column: Attachments size
# 21 Feb 2022
Issue grouping, Easy Agile Programs columns
- Group issues by field values
- In addition to hierarchy levels, use grouping levels in custom issue structures
- Easy Agile Program column
- Easy Agile Program increment column
- Level-specific column filtering preference now also applies to the table search
# 8 Feb 2022
Global permissions, read-only columns
- Manage who can view and create, edit, delete sheets via global permissions
- Optionally make columns read-only in your sheets
# 3 Feb 2022
Custom fields support
- Custom field type: Single-version select menu
- Custom field type: Multi-version select menu
- Custom field type: Readonly plain text
# 2021
# 28 Dec 2021
Expand/collapse levels
- Expand and collapse entire levels from the context menu when issue hierarchy is enabled
# 23 Dec 2021
Relative date column filtering
- Filter date and time columns relative to now (e.g. today, or from yesterday to X days from now, etc.)
# 16 Dec 2021
Hierarchy level filtering and level-specific column filtering
- Hide issues without children in hierarchies
- Control which hierarchy levels column filtering applies to
# 10 Dec 2021
Row numbers
- Optionally add row numbers for easier referencing of table positions in meetings
# 6 Dec 2021
Rename columns
- Change the heading of table columns in your sheets
# 29 Nov 2021
Advanced search syntax with logical operators
- Use logical operators (OR, AND, NOT), grouping (parentheses) and exact phrasing (quotation marks) in text column filtering and table search field
# 24 Nov 2021
Custom field support
- Custom field type: Projects
# 23 Nov 2021
Adaptable sheets
- Open sheets with an adapted scope and title using URL parameters
# 22 Nov 2021
Time tracking formats, expand/collapse all issues
- Time tracking columns now observe Jira display format and default unit settings
- Expand and collapse issues actions in context menu when issue hierarchy is enabled
# 17 Nov 2021
Custom issue hierarchy
- Create custom structures based on Advanced Roadmaps parent linkage, issue links, and more
# 4 Oct 2021
Sheet starring
- You can now pin your favourite sheets in the sheets directory and sheets menu by starring them
# 1 Oct 2021
Sheets browsing improvements
- Switch between recent and alphabetical sorting in sheets directory and sheets menu
# 28 Sep 2021
SLA columns
- Table columns for Jira Service Management SLA time fields
# 23 Sep 2021
Issue hierarchy
- Group issues by hierarchical relationships (Advanced Roadmaps issue levels also coming soon)
# 3 Sep 2021
Special Notes column
- Add issue notes that are visible in the context of the sheet you add them to (not a Jira field)
# 26 Aug 2021
Editable Epic link cells
- Cells in Epic link columns are now also editable
# 3 Aug 2021
Notifications switch and more granular sheet permissions
- Toggle email notifications of issue changes in sheets (needs administrator permission)
- You now need Edit Issues permission in a project to create, edit, delete sheets
# 27 Jul 2021
Faster column editing
- More lightweight Add column dialog for snappier sheet editing
# 20 Jul 2021
Inline create issues in sheets
- Hover over the row handles on the left of the table to create an issue
- Choose "Create issue below" in the cell context menu to create an issue
- Use keyboard shortcut Cmd+Shift+C (macOS) or Ctrl+Shift+C (Windows, Linux) to create an issue
# 8 Jul 2021
Epic link column improvements
- Epic Link cells now show the name and colour of the epic
# 29 Jun 2021
Row handles, time columns, custom field column header abbreviation
- Row handles
- Click row or column headers to select whole rows or columns
- Status category changed date column
- Resolved date column
- Smart column: Time since created
- Smart column: Time since updated
- Smart column: Time since status category changed
- Smart column: Time since resolved
- Column headers with long custom field names now get a smart abbreviation when needed
# 14 Jun 2021
Context menu, more JSM columns
- New context menu for cell selections
- Start Jira bulk editing for selected issues
- Request type column (Jira Service Management)
- Request language column (Jira Service Management)
- Satisfaction column (Jira Service Management)
- Satisfaction date column (Jira Service Management)
# 9 Jun 2021
Sheet directory page, more JSM columns, cascading select custom field support
- New sheet directory page accessible from the Jira header navigation
- Custom field type: Cascading select menu
- Request participants column (Jira Service Management)
- Approvers column (Jira Service Management)
# 31 May 2021
Save as new sheet, Votes, Watchers, Tempo columns, more custom fields support
- Ability to save sheet as a new sheet
- Ability to clear all sorting, filtering, sheet search from the status bar
- Overdue date values in the Due date column now appear red
- Votes column
- Watchers column
- Tempo team column
- Tempo account column
- Custom field type: Multi-user select menu
- Custom field type: Single and multi-user select menus (next-gen projects)
- Custom field type: Single-group select menu
- Custom field type: Multi-group select menu
# 17 May 2021
Sheet export
- Sheet export to XLSX, CSV, TSV files
# 10 May 2021
Comments and Status category columns
- Comments column
- Customer conversation column (Jira Service Management)
- Status category column
# 3 May 2021
Column filtering, Advanced Roadmaps columns
- Number-based column filtering
- Date-based column filtering
- Date and time-based column filtering
- Time tracking value-based column filtering
- Flagged option-based column filtering
- Paren link column (Advanced Roadmaps)
- Target start date column (Advanced Roadmaps)
- Target end date column (Advanced Roadmaps)
- Team column (Advanced Roadmaps)
# 28 Apr 2021
Column filtering
- Field value-based column filtering
# 21 Apr 2021
Attachments column, more custom fields support, more performance, issue dialog
- Attachments column
- Custom field type: Multi-line plain text
- Custom field type: Multi-choice select menu
- Custom field type: Date and time
- Custom field type: Checkboxes
- Custom field type: Radio buttons
- Custom field type: Single-user select menu (classic projects)
- Custom field type: Labels
- Issue dialog
- Performance improvements
# 13 Apr 2021
Column filtering, performance, more custom fields support
- String-based column filtering for text fields
- Performance improvements
- Custom field type: URL
- Custom field type: Date
# 8 Apr 2021
Custom fields support
- Custom field type: Single-line plain text
- Custom field type: Single-choice select menu
- Custom field type: Number
# 29 Mar 2021
Initial public release
- Multiple sheets per project
- Easy-to-use JQL composer for sheet scope editing
- Add, remove and re-arrange table columns
- Search in sheet
- Column sorting
- Column resizing
- Support for most standard fields, time tracking fields, and Jira Software fields
- Keyboard commands and navigation
- Select, copy and paste single or multiple cells
- Undo and redo cell changes
- Status bar for cell range calculations and more
- Next-gen project compatibility