Google Sheets Synchronization - Supported Field Types
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 Reporter, Assignee, and any single user picker custom fields
Version: Fields such as Affects Version/s and Fix Version/s
Labels: Issue labels
Priority: Issue priority
Status: Issue status
Estimate: Fields such as Original Estimate and Remaining Estimate
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. Changes may also be prevented if a field is not present in Jira's screen for the issue. In any of these cases the add-on will display a message to the user.