This article describes available column types in Table Grid Editor for Jira Cloud.
String
The column is used to enter a single line of text.
Textarea
Allows adding plain text, including paragraphs. The column is available for JQL search. You can set maximum number of characters in the column configuration. In order to add a new paragraph in the table cell, please use Ctrl+Enter hotkey.
List
Create a list of options using this column type. There are static and dynamic options; you can combine them in one column. Configure dynamic options using an external data source.
Integer
Use this type to store plane integer number.
Number
Use this type to store number fields with a decimal.
Checkbox
Use this type to display a checkbox. By default the checkbox is not set. This type uses boolean values.
Userlist
Allows selecting JIRA User using a dropdown list. A cell will display User avatar alongside User display name.
Date
Use this type to store date data. You can set custom format or select the predefined presets based on locale. The default format is set to 'L'.
DateTime
Allows storing date and time data. You can set custom format or select the predefined date and time presets based on locale. The default format for is set to 'L' for date and 'hh: mm A' for time.
Time
Allows storing time data. You can set custom format or select the predefined presets based on locale. The default format is set to 'hh: mm A'.
Formula
Allows executing formula expression written in JavaScript. Displays a result of the formula specified in the column configuration.
You can aggregate formula results in the grid.
Sequence
Allows adding an auto-countable column using a desired step. You can configure the step in the column configuration.
Default step is set to 1. You can use it in JQL search. This column type cannot be used in filters.