Keep Related Jira Issues Together with Smartsheet Hierarchy

Keep synched Jira issues organized and sorted to maintain consistency and readability in your sheet.  

Who can use this capability?

Permissions and roles The Workflow Owner can define row groups when creating workflows or edit an existing workflow to define row groups. Licensed Smartsheet users who also have access to the Jira Connector can create a new workflow and define row groups.
plan types Smartsheet accounts that have purchased the Jira Connector.

Enable or Disable Row Groups

By default, Jira Connector Workflows will maintain your Epic, Story, Task, and Subtask relationships from Jira. For example, issues that are children of an Epic will appear in the sheet beneath that Epic as child rows.

To disable this, uncheck Maintain JIRA hierarchy grouping: Epic, Story, Task, Subtask, etc. in the Row Groups section of the Workflow Wizard.

new row grouping screenshot

Automatically Sort Synced Issues in Row Groups

You can group issues by any field value available for your project in Jira (Issue Type and Priority for example). If Jira hierarchy is maintained in your workflow, child issues will still be sorted under their parent issue.

Issues sorted by priority

Define Custom Row Groups

Sort by values other than the fields available in Jira with a custom row group. For example, if you want to incorporate your Jira issues into other project information within Smartsheet, custom row grouping can help you place your Jira issues where you want them in the sheet. 

further options for defining row groups

When you define custom row groups, you’ll work with the Primary column in a sheet to create a hierarchy. Here are the ways that you can go about this:

  • Use an existing value—type an existing Primary column value of a row in your sheet to group Jira issues. It's important to make sure that you type the Primary Column value exactly as it appears in the sheet.
  • Create a new value—do this to create a new parent row to group Jira issues.

If your custom row group isn’t placed within existing hierarchy, the new parent row will appear at the bottom of your sheet.

row grouping example

Troubleshoot Row Group Behavior 

Keep the following in mind when defining row groups:

  • If your Issue Key field is mapped to a column that is not the Primary Column in the sheet, you will not be able to create new issues from Smartsheet while Row Grouping is enabled.
  • Issues that don’t have a grouping value set in Jira will be placed in a hierarchy named “Field ‘[Group]’ not set”. 
  • If “Maintain JIRA hierarchy grouping: Epic, Story, Task, Subtask, etc.” is checked in the workflow, and a parent issue doesn’t have a group by value set in Jira, the child rows will fall under the “Field ‘[Group]’ not set” hierarchy also. To resolve this, uncheck the maintain Jira hierarchy option in your workflow or consider other row grouping options.
  • When using custom row groups to sort rows beneath Primary Column values in the sheet, you must define the entire ancestry in your row grouping configuration. Otherwise, the custom row group you set up will appear as a new parent row at the bottom of the sheet.
     
Was this article helpful?
YesNo