The Jira Integration Google Sheets add-on currently supports the following Jira field types for synchronization from Google Sheets back to Jira:
- String: Fields such as Description, Summary, Environment, and text entry custom fields
- User: Fields such as Creator, Reporter, and Assignee, and any single user picker custom fields
- Priority: Issue priority
- Status: Issue status
- Date/Datetime: Fields such as Due Date, Resolution Date, and date/date time picker custom fields
- Option: Custom fields that use single-select drop down fields
- Number: Custom fields that require numbers as input
Note that your Jira instance may prevent the add-on from changing certain fields, such as Resolution Date, based on workflow or transition configuration. In these cases the add-on will display a message to the user.