# 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 Projects, Service management Projects, Business Projects, and Product discovery Projects (Cloud) system Fields, locked Fields, and other work item 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 |
|---|---|---|
| Work type Issue type | ||
| Work item key 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 of sub-task | ||
| Sub-tasks | ||
| Work item links 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 | ||
| Work item 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 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 |
# Third-party fields
Most Fields of text, number, date, datetime, and select types by third-party apps are supported as table columns. JXL also offers dedicated columns for the following third-party apps' Fields:
# Smart columns
Calculated and other work item data-related 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 work item links Number of issue links | ||
| Number of linked work items 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) | ||
| Affected version status (configurable) | ||
| Affected version description (configurable) | ||
| Fix version status (configurable) | ||
| Fix version description (configurable) | ||
| Time to or since start date | ||
| Time to or since due date | ||
| Time to or since target start | ||
| Time to or since target end | ||
| Last attachment | ||
| Attachments size | ||
| Images | ||
| Parent (merged Parent, Epic link, Parent link) | ||
| Parent work type Parent issue type | ||
| Parent priority | ||
| Parent status | ||
| Parent summary | ||
| Sub-tasks progress | ||
| Sub-tasks done percentage | ||
| Sub-task statuses | ||
| Work item link descriptions Issue link descriptions | ||
| Work item link types Issue link types | ||
| Linked work items Linked issues | ||
| Linked work item statuses Linked issue statuses | ||
| Linked work types Linked issue types | ||
| Work item URL Issue URL | ||
| Customer portal work item URL Customer portal issue URL | ||
| Work item ID Issue ID | ||
| Project key | ||
| Project ID | ||
| Project type | ||
| Project configuration type | ||
| Domain of reporter | ||
| Domain of assignee | ||
| Request channel | ||
| SLA - Goal duration | ||
| SLA - Time elapsed | ||
| SLA - Time remaining | ||
| SLA - Time since breached | ||
| SLA - Progress | ||
| SLA - Cycle status | ||
| SLA - Met vs breached | ||
| SLA - Start time | ||
| SLA - Finish time | ||
| SLA - Breach time | ||
| Date custom field - Time to or since value | ||
| Datetime custom field - Time to or since value (configurable) | ||
| Multi value custom field - Number of values | ||
| Satisfaction comment | ||
| All comments | ||
| All commenters | ||
| First comment | ||
| First comment visibility | ||
| Date of first comment | ||
| Time since first comment (configurable) | ||
| First commented by user | ||
| Last comment | ||
| Last comment visibility | ||
| Date of last comment | ||
| Time since last comment (configurable) | ||
| Last commented by user | ||
| First internal comment | ||
| Date of first internal comment | ||
| Time since first internal comment (configurable) | ||
| First internally commented by user | ||
| Last internal comment | ||
| Date of last internal comment | ||
| Time since last internal comment (configurable) | ||
| Last internally commented by user | ||
| All external comments | ||
| First external comment | ||
| Date of first external comment | ||
| Time since first external comment (configurable) | ||
| First externally commented by user | ||
| Last external comment | ||
| Date of last external comment | ||
| Time since last external comment (configurable) | ||
| Last externally commented by user | ||
| First comment by customer | ||
| Date of first comment by customer | ||
| Time since first comment by customer (configurable) | ||
| First commented by customer | ||
| Last comment by customer | ||
| Date of last comment by customer | ||
| Time since last comment by customer (configurable) | ||
| Last commented by customer | ||
| First response to customer | ||
| Date of first response to customer | ||
| Time since first response to customer (configurable) | ||
| First responded to customer by user | ||
| Time between created and first response to customer | ||
| Last response to customer | ||
| Date of last response to customer | ||
| Time since last response to customer (configurable) | ||
| 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.
In cells of this column, you can add notes to a Work item. 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 Work item 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 Work item.)
# History columns
Columns offered by JXL, that surface historical work item-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 (configurable) | ||
| Time since created (configurable) | ||
| Time since updated (configurable) | ||
| Time since resolved (configurable) | ||
| Time between created and resolved | ||
| Last viewed date | ||
| Time since last viewed (configurable) | ||
| Date of last public activity | ||
| Time since last public activity (configurable) | ||
| Last update action | ||
| Last updated by user | ||
| Number of updates | ||
| Date of last attachment | ||
| Time since last attachment |
# Time in status v3.5.1
This History column offers 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
Work calendar v3.6.1
Optionally create a Work calendar to ensure only your work time is taken into consideration.
# Time between statuses v3.5.1
This History column offers 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 Work item is transitioned into or created in the specified Status or Statuses
- Transition to - When the Work item is transitioned to into the specified Status or Statuses
- Creation in - When the Work item is created in the specified Status or Statuses
- Transition from - When the Work item 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 Work item is transitioned into the specified Status or Statuses
- Transition from or now in - When the Work item is transitioned away from or is currently in the specified Status or Statuses
- Transition from - When the Work item is transitioned away from the specified Status or Statuses
- Now in - When the Work item 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
Work calendar v3.6.1
Optionally create a Work calendar to ensure only your work time is taken into consideration.
# Time with assignee v3.5.2
This History column offers 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
Work calendar v3.6.1
Optionally create a Work calendar to ensure only your work time is taken into consideration.
# Time in status with assignee v3.5.2
This History column offers 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
Work calendar v3.6.1
Optionally create a Work calendar to ensure only your work time is taken into consideration.
# Time between statuses with assignee v3.5.2
This History column offers 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 Work item is transitioned into or created in the specified Status or Statuses
- Transition to - When the Work item is transitioned to into the specified Status or Statuses
- Creation in - When the Work item is created in the specified Status or Statuses
- Transition from - When the Work item 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 Work item is transitioned into the specified Status or Statuses
- Transition from or now in - When the Work item is transitioned away from or is currently in the specified Status or Statuses
- Transition from - When the Work item is transitioned away from the specified Status or Statuses
- Now in - When the Work item 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
Work calendar v3.6.1
Optionally create a Work calendar to ensure only your work time is taken into consideration.
# Date of / Time since status v3.5.2
This History column offers the following configuration options.
Status
Specify the exact trigger point you'd like the measure.
- Transition to or creation in - When the Work item is transitioned into or created in the specified Status or Statuses
- Transition to - When the Work item is transitioned to into the specified Status or Statuses
- Transition from or now in - When the Work item is transitioned away from or is currently in the specified Status or Statuses
- Transition from - When the Work item 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
Work calendar v3.6.1
Optionally create a Work calendar to ensure only your work time is taken into consideration.
# Date of / Time since status changed v3.5.2
This History column offers 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
Work calendar v3.6.1
Optionally create a Work calendar to ensure only your work time is taken into consideration.
# Number of statuses v3.5.2
This History column offers 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 offers 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 offers 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
