# 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
Updated: 29 Jan 2023