# Supported fields

Request fields

If you come across a Field that's missing or that you think should work differently, feel free to let us know (opens new window) and we'll look into it.

# Jira system fields

Jira Software, Jira Service Management, Jira Product Discovery, and Jira Work Management / Jira Core system Fields, locked Fields, and other issue properties and data supported by JXL. Edit functionality is offered inline in the table cells, in bespoke dialogs, and/or via pasting. Not all Fields exist in Jira Cloud, Jira Data Center and Jira Server.

Fields and data View Edit
Issue type
Issue key
Summary
Description
Priority
Assignee
Reporter
Status
Status category
Resolution
Created date
Updated date
Resolved date
Start date
Due date
Labels
Components
Affects versions
Fix versions
Environment
Rank
Project
Project category
Parent
Parent
Sub-tasks
Issue links (configurable)
Attachments
Votes
Watchers
Security level
Original estimate
Time spent
Remaining estimate
Progress
Work ratio
Σ Original estimate
Σ Time spent
Σ Remaining estimate
Σ Progress
Category
Flagged
Sprint
Epic name
Epic link
Epic status
Epic/Theme
Epic color
Issue color
Story point estimate
Business value
Target start
Target end
Team
Parent link
Number of pull requests
Pull requests status
Number of builds
Builds status
Organizations
Organizations
Approvers
Request participants
Request type
Request type
Request language
Satisfaction
Satisfaction date
SLA time fields
Affected services
Major incident
Atlas project key
Atlas project status

# Custom field types

Custom field types supported by JXL.

Field types View Edit
Single line text (Short text)
Single line text read-only
Multiple line text (Paragraph)
Single choice select list (Dropdown)
Multiple choice select list
Date picker
Datetime picker (Time stamp)
Number
URL (Hyperlink)
Checkboxes
Radio buttons
Labels picker
Single people picker
Multiple people picker
Single group picker
Multiple group picker
Cascading select list (Dependent dropdown)
Project picker
Single version picker
Multiple version picker
Global rank
Assets object picker
Assets single referenced object picker
Assets multiple referenced object picker
Rating
Date range picker (Interval)
Checkbox (Boolean)
Slider
Reactions Soon Soon
Vote Soon Soon
Custom formula Soon

# Third-party fields

Third-party apps' Fields supported by JXL.

Fields View Edit
Easy Agile Programs (opens new window) Program
Easy Agile Programs (opens new window) Program increment
Elements Connect (opens new window) Live text custom field
Elements Connect (opens new window) legacy Live text custom field
Elements Connect (opens new window) Live user custom field
Elements Connect (opens new window) Snapshot text custom field
Elements Connect (opens new window) Snapshot date custom field
Elements Connect (opens new window) Snapshot datetime custom field
eSign (opens new window) Signature export
eSign (opens new window) Signature count
eSign (opens new window) Signature finalised
eSign (opens new window) Signature pending
eSign (opens new window) Signature status count
eSign (opens new window) Signed by
eSign (opens new window) Signed on
Issue Checklist (opens new window) Checklist
Issue Checklist (opens new window) Checklist completed
Issue Checklist (opens new window) Checklist progress
Issue Checklist (opens new window) Checklist progress %
JMCF (opens new window) Number custom field
JMCF (opens new window) Date custom field
JMCF (opens new window) Date/Time custom field
JQL Search Extensions (opens new window) Attachment count
JQL Search Extensions (opens new window) Bugs of Epic count
JQL Search Extensions (opens new window) Bugs of Epic in Done status category count
JQL Search Extensions (opens new window) Bugs of Epic in In Progress status category count
JQL Search Extensions (opens new window) Bugs of Epic in To Do status category count
JQL Search Extensions (opens new window) Children of Epic count
JQL Search Extensions (opens new window) Children of Epic in Done status category count
JQL Search Extensions (opens new window) Children of Epic in In Progress status category count
JQL Search Extensions (opens new window) Children of Epic in To Do status category count
JQL Search Extensions (opens new window) Comment count
JQL Search Extensions (opens new window) Issue link count
JQL Search Extensions (opens new window) Stories of Epic count
JQL Search Extensions (opens new window) Stories of Epic in Done status category count
JQL Search Extensions (opens new window) Stories of Epic in In Progress status category count
JQL Search Extensions (opens new window) Stories of Epic in To Do status category count
JQL Search Extensions (opens new window) Subtask count
JQL Search Extensions (opens new window) Updated by users count
JWT (opens new window) Calculated text custom field
JWT (opens new window) Calculated number custom field
Multi-Level Cascading Select (opens new window) custom field
ScriptRunner (opens new window) Script Field custom field
ScriptRunner (opens new window) Single Issue Picker custom field
ScriptRunner (opens new window) Multiple Issue Picker custom field
Smart Fields (opens new window) Smart text custom field
Smart Fields (opens new window) Smart number custom field
Tempo (opens new window) Team
Tempo (opens new window) Account
Tempo (opens new window) Team
Tempo (opens new window) Account

# Smart columns

Calculated and other issue-related data columns offered by JXL.

Data View Edit
Number of labels
Number of components
Number of affected versions
Number of fix versions
Number of sub-tasks
Number of issue links
Number of linked issues
Number of attachments
Number of comments
Number of sprints
Number of affected services
First sprint
Last sprint
Active sprint
Open sprint
Future sprint
Sprint status
Sprint closure
Sprint goal
Affected version release date (configurable)
Time since affected version release date (configurable)
Fix version release date (configurable)
Time to fix version release date (configurable)
Time to due date
Attachments size
Images
Parent issue type
Parent priority
Parent status
Parent summary
Sub-tasks progress
Issue link descriptions
Issue link types
Linked issues
Linked issue statuses
Linked issue types
Issue URL
Customer portal issue URL
Issue ID
Project key
Project ID
Project type
Project configuration type
Request channel
Satisfaction comment
All comments
All commenters
First comment
First comment visibility
Date of first comment
Time since first comment
First commented by user
Last comment
Last comment visibility
Date of last comment
Time since last comment
Last commented by user
First internal comment
Date of first internal comment
Time since first internal comment
First internally commented by user
Last internal comment
Date of last internal comment
Time since last internal comment
Last internally commented by user
All external comments
First external comment
Date of first external comment
Time since first external comment
First externally commented by user
Last external comment
Date of last external comment
Time since last external comment
Last externally commented by user
First comment by customer
Date of first comment by customer
Time since first comment by customer
First commented by customer
Last comment by customer
Date of last comment by customer
Time since last comment by customer
Last commented by customer
First response to customer
Date of first response to customer
Time since first response to customer
First responded to customer by user
Last response to customer
Date of last response to customer
Time since last response to customer
Last responded to customer by user
Notes

Smart column: Notes

This column is only available in JXL for Jira Cloud, not in JXL for Jira Data Center and Server.
In cells of this column, you can add notes to an Issue. These notes are only shown in the context of the particular Sheet you added them to, and they become inaccessible if you delete the Sheet. This is not a Jira Field and its information not visible on the Issue view. (However, the data is not encrypted and could be accessed via the Issue Property API by any User who has Permission to view the relevant Issue.)

# History columns

Columns offered by JXL, that surface historical issue-related data. Some of these columns require configuration and some might negatively affect the loading time of the Sheet they're used in significantly, depending on the amount of historical data loaded from Jira.

Data View Edit
Time in status (configurable)
Time between statuses (configurable)
Time with assignee (configurable)
Time in status with assignee (configurable)
Time between statuses with assignee (configurable)
Date of status (configurable)
Time since status (configurable)
Date of status change (configurable)
Time since status changed (configurable)
Number of statuses (configurable)
Number of status changes (configurable)
Number of assignee changes (configurable)
Previous status
Date of status category change
Time since status category changed
Time since created
Time since updated
Time since resolved
Last viewed date
Time since last viewed
Date of last public activity
Time since last public activity
Time between created and resolved
Last update action
Last updated by user
Number of updates

# Time in status v3.5.1

This History column requires the following configuration options.

Status

Choose one or multiple Statuses that you'd like to be triggers for the measurement.

Occurrences

Specify which occurrence/s of triggers you'd like the measurement to entail, in case there are multiple occurrences.

  • Latest - Capture the last occurrence
  • Earliest - Capture the first occurrence
  • Shortest - Capture the shortest occurrence
  • Longest - Capture the longest occurrence
  • Average - Calculate the average length of all occurrences
  • Median - Calculate the median length of all occurrences
  • All - Capture and sum up all occurrences
  • All including gaps - Capture and sum up all occurrences and include gaps between them

# Time between statuses v3.5.1

This History column requires the following configuration options.

From status

Specify the exact trigger point when you'd like the measurement to begin.

  • Transition to or creation in - When the Issue is transitioned into or created in the specified Status or Statuses
  • Transition to - When the Issue is transitioned to into the specified Status or Statuses
  • Creation in - When the Issue is created in the specified Status or Statuses
  • Transition from - When the Issue is transitioned away from the specified Status or Statuses

Choose one or multiple Statuses in which you'd like the measurement to begin.

To status

Specify the exact trigger point when you'd like the measurement to end.

  • Transition to - When the Issue is transitioned into the specified Status or Statuses
  • Transition from or now in - When the Issue is transitioned away from or is currently in the specified Status or Statuses
  • Transition from - When the Issue is transitioned away from the specified Status or Statuses
  • Now in - When the Issue is currently in the specified Status or Statuses

Choose one or multiple Statuses in which you'd like the measurement to end.

Occurrences

Specify which occurrence/s of triggers you'd like the measurement to entail, in case there are multiple occurrences.

  • Latest - Capture the last occurrence
  • Earliest - Capture the first occurrence
  • Shortest - Capture the shortest occurrence
  • Longest - Capture the longest occurrence
  • Average - Calculate the average length of all occurrences
  • Median - Calculate the median length of all occurrences
  • All - Capture and sum up all occurrences
  • All including gaps - Capture and sum up all occurrences and include gaps between them

# Time with assignee v3.5.2

This History column requires the following configuration options.

Assignee

Choose one or multiple Users that you'd like to be triggers for the measurement.

Occurrences

Specify which occurrence/s of triggers you'd like the measurement to entail, in case there are multiple occurrences.

  • Latest - Capture the last occurrence
  • Earliest - Capture the first occurrence
  • Shortest - Capture the shortest occurrence
  • Longest - Capture the longest occurrence
  • Average - Calculate the average length of all occurrences
  • Median - Calculate the median length of all occurrences
  • All - Capture and sum up all occurrences
  • All including gaps - Capture and sum up all occurrences and include gaps between them

# Time in status with assignee v3.5.2

This History column requires the following configuration options.

Status

Choose one or multiple Statuses that you'd like to be triggers for the measurement.

Assignee

Choose one or multiple Users that you'd like to be triggers for the measurement.

Occurrences

Specify which occurrence/s of triggers you'd like the measurement to entail, in case there are multiple occurrences.

  • Latest - Capture the last occurrence
  • Earliest - Capture the first occurrence
  • Shortest - Capture the shortest occurrence
  • Longest - Capture the longest occurrence
  • Average - Calculate the average length of all occurrences
  • Median - Calculate the median length of all occurrences
  • All - Capture and sum up all occurrences
  • All including gaps - Capture and sum up all occurrences and include gaps between them

# Time between statuses with assignee v3.5.2

This History column requires the following configuration options.

From status

Specify the exact trigger point when you'd like the measurement to begin.

  • Transition to or creation in - When the Issue is transitioned into or created in the specified Status or Statuses
  • Transition to - When the Issue is transitioned to into the specified Status or Statuses
  • Creation in - When the Issue is created in the specified Status or Statuses
  • Transition from - When the Issue is transitioned away from the specified Status or Statuses

Choose one or multiple Statuses in which you'd like the measurement to begin.

To status

Specify the exact trigger point when you'd like the measurement to end.

  • Transition to - When the Issue is transitioned into the specified Status or Statuses
  • Transition from or now in - When the Issue is transitioned away from or is currently in the specified Status or Statuses
  • Transition from - When the Issue is transitioned away from the specified Status or Statuses
  • Now in - When the Issue is currently in the specified Status or Statuses

Choose one or multiple Statuses in which you'd like the measurement to end.

Assignee

Choose one or multiple Users that you'd like to be triggers for the measurement.

Occurrences

Specify which occurrence/s of triggers you'd like the measurement to entail, in case there are multiple occurrences.

  • Latest - Capture the last occurrence
  • Earliest - Capture the first occurrence
  • Shortest - Capture the shortest occurrence
  • Longest - Capture the longest occurrence
  • Average - Calculate the average length of all occurrences
  • Median - Calculate the median length of all occurrences
  • All - Capture and sum up all occurrences
  • All including gaps - Capture and sum up all occurrences and include gaps between them

# Date of / Time since status v3.5.2

This History column requires the following configuration options.

Status

Specify the exact trigger point you'd like the measure.

  • Transition to or creation in - When the Issue is transitioned into or created in the specified Status or Statuses
  • Transition to - When the Issue is transitioned to into the specified Status or Statuses
  • Transition from or now in - When the Issue is transitioned away from or is currently in the specified Status or Statuses
  • Transition from - When the Issue is transitioned away from the specified Status or Statuses

Optionally choose one or multiple specific Statuses that you'd like to be triggers for the measurement.

Occurrences

Specify which occurrence of triggers you'd like the measurement to entail, in case there are multiple occurrences.

  • Latest - Capture the last occurrence
  • Earliest - Capture the first occurrence

# Date of / Time since status changed v3.5.2

This History column requires the following configuration options.

From status

Optionally choose one or multiple specific origin Statuses that you'd like to be triggers for the measurement.

To status

Optionally choose one or multiple specific destination Statuses that you'd like to be triggers for the measurement.

Occurrences

Specify which occurrence of triggers you'd like the measurement to entail, in case there are multiple occurrences.

  • Latest - Capture the last occurrence
  • Earliest - Capture the first occurrence

# Number of statuses v3.5.2

This History column requires the following configuration options.

Status

Optionally choose one or multiple specific Statuses that you'd like to be triggers for the measurement.

# Number of status changes v3.5.2

This History column requires the following configuration options.

From status

Optionally choose one or multiple specific origin Statuses that you'd like to be triggers for the measurement.

To status

Optionally choose one or multiple specific destination Statuses that you'd like to be triggers for the measurement.

# Number of assignee changes v3.5.4

This History column requires the following configuration options.

From user

Optionally choose one or multiple specific origin Users that you'd like to be triggers for the measurement.

To user

Optionally choose one or multiple specific destination Users that you'd like to be triggers for the measurement.

# Merged columns

In JXL for Jira Cloud, you can use merged columns that consolidate values from multiple individual Fields from Team-managed projects.

This is helpful when you'd like to roll up these Fields in one Sheet. Fields in Team-managed projects are separate, unrelated entities and would otherwise be displayed in separate columns.

If there are multiple Fields with the exact same name and a similar Field type configured in your Jira site, across both Team-managed projects and Company-managed projects, JXL offers a merged column that you can add to your Sheets. The following similar Field types will be joined in these columns, as long as the relevant Fields have the exact same name.

Text fields

  • Single line text (Short text)
  • Multiple line text (Paragraph)
  • Single line text read-only

Select list fields

  • Single choice select list (Dropdown)
  • Multiple choice select list
  • Cascading select list (Dependent dropdown)
  • Checkboxes

People fields

  • Single people picker
  • Multiple people picker

Group fields

  • Single group picker
  • Multiple group picker

Version fields

  • Single version picker
  • Multiple version picker

Date fields

  • Date picker
  • Date range picker (Interval)

Number fields

  • Number
  • Rating
  • Slider
Updated: 6 Feb 2024