Table Features

GanttTable’s Excel-like tables empower you to browse, edit, and track Jira issues across multiple projects with ease. Leverage built-in Jira hierarchies or create custom structures to organize tasks and sprints, tailoring workflows to you or your team’s needs.

Filter

GanttTable supports Filter to refine and narrow down data fields and quickly locate relevant Jira issues.

Check the list to see supported fields in GanttTable.

Currently, the Filter feature uses either Basic or JQL. For example, you can fill in the JQL filter box with assignee=… AND priority=… to filter Jira issues from a specific member with a certain level of priority.

Keep in Mind

JQL filters require valid syntax to avoid errors. For more details, please visit Atlassian’s JQL fields and JQL keywords to use this function properly.

Here is an example of using the Basic filter:

You can switch between AND and OR conditions for a different filtering result.

 

To add more rules in the Filter condition, click + Add nested filter → click Apply.

To remove a condition in the Filter, click the Delete icon.

To add more filter rule, click + Add filter → click Apply.

You can also switch between AND and OR conditions for additional filters.

Search

Quickly locate specific tasks or Jira issues by using the Search feature.

To utilize the Search feature, please use either the Issue key or Summary.

💡

TIP

If you search by using the project key or summary, all the issue with the same search term will be located.

Colors

GanttTable is equipped with a Color mark feature to help you work with the issue structure sheet more easily.

With this, users can quickly add colors to multiple cells or rows in the structure table at the same time.

Locate the Colors button. Then, you can add a new rule to start setting a new color condition.

In the dialog, you can choose which field will be used for the condition and the value related to that field. (For example, in the image below, we’re selecting Priority and choosing the ‘High’ priority as the condition)

You can also add a Nested condition in the same rule for additional color conditions of the rule.

Next, move on to the Format row, where you can decide whether you want to assign color to specific cells or the entire row of the structure table.

When coloring cells only, you will have to select the target cells to make it work. (If you want to color the whole row, you don’t have to choose the target cell.)

All you have to do now is choose the color you want. Currently, GanttTable supports adding color to:

• Background

• Border

• Text

If you want to add another color to the table, simply create a new rule for the Color condition.

However, keep in mind that all condition rules will have priority in ascending order. In other words, the first color condition on the list will be prioritized to avoid overlapping.

You can also freely change the order of these color conditions by using drag-and-drop.

Sorting

Use the Sort feature to arrange Jira issues in the table by a chosen column in ascending or descending order.

View preferences

1. What is View in GanttTable?

View represents how the app visualizes your Jira issues and projects in the portfolio. Each different view tells a different story based on the settings, filters, and structure of the table.

Keep in mind that when creating a new view, it will have the same filters and settings as your currently selected view in GanttTable.

2. Manage Columns in GanttTable

You can add more (or remove) Jira fields and labels to GanttTable as columns and manage them in the Table.

Add columns to the table

By default, GanttTable will generate a board using your Jira project’s issue keys and Summary as data fields in the table. You can add more to your preferences.

To add more data to the table as columns, click the ➕ button next to the column and search for fields you want to add .

After choosing what data or fields you want to add to the table, click outside the menu to close it, and the table will automatically updates to load the new columns.

There are certain fields (both Jira default and custom) that GanttTable can support. For more details, please visit Supported fields.

Remove columns

To remove a column from the table, you can hover the cursor over a column clicking ✖️.

This can be helpful if you want to create different Saved views using different column layouts.

For example: this allows you to switch between different column layouts on the same board which can be used for different teams or projects.

Resize and Arrange the columns

You can narrow or widen a table column by clicking the right-hand-side border of its column cell and dragging it horizontally to adjust it.

You can adjust the column order freely by hovering the cursor over the dots symbol. Then, click and drag the column to a new position.

Freeze a column

By default, the app freezes the Issue key and Summary columns on the left. You can freeze other columns as well by using the pin function.

Hover the cursor over the column you want to freeze, click 📍 to pin a column to avoid scrolling it away.

This is helpful if you want to utilize both the spreadsheet and the gantt feature while keeping important data field visible.

To unfreeze a column, simply hover over that column again and click the 📍 with a / to remove the pin.

3. How to create a new view (Saved views)?

Before creating a new view, make sure that you have selected the settings and structure you desire in the table.

1. From your current view in the app, simply click the View menu dropdown → choose + Create new view.

2. Name this view so other members can recognize it easily.

3. Check the box to set it as a default view for everyone whenever they access your portfolio.

Once done, click Create.

You can always change the default view in the portfolio settings. Additionally, you can delete your saved views here.

For more details, please visit Saved views in Settings & Preferences.

With that, you've created a saved views that you can switch between one another for different purposes of use or different workflows.

Structure Hierarchy

1. What is the Structure in GanttTable?

The Structure provides a unique way for you to visualize and manage your tasks, sprints, and projects in the most convenient way possible.

At default, the GanttTable uses the Jira hierarchy structure.

This structure allows you and your team to manage work at different levels of granularity, ensuring that large strategic goals (Epics) are broken down into smaller, actionable tasks (Sub-tasks).

You can also choose the Flat structure for a simpler approach to managing your work items.

2. Custom structure

You can customize your own structures using your own rules to organize your work on the table based on Group, Total, and Group and total.

You can save this new structure as a new view and use it again later. Or, you can also set it as the default view for other members.

For more details, please read How to create a new view (Saved views). 

For example, you can create a custom structure showing Sprint, Assignees, Component, and custom select fields.

3. Using Hierarchy in a Group by Structure

When creating a custom structure, GanttTable also supports visualizing hierarchy for how you group and organize work on the table.

At the moment, you can now choose between different hierarchy styles:

• Flat

• Jira

• Custom

For Custom hierarchy in structure, GanttTable uses the Issue link to visualize the hierarchy among issues on the table.

Its purpose is to empower users to make a flexible hierarchy in the Group by Structure using the issue link type.

 

So, users can build and organize a nested issue system with Jira’s or a special issue link type that users have already defined in their instance.

🗳️ Contact Support ❓Frequently Asked Questions 🌟 Rate Us

📑 Release Notes 🔐Trust Center