Cell to Jira Field Mapping

The Cell to Jira Field Mapping function lets you update Jira field values directly from your table. You can either enter values manually or use Excel-like formulas to automate updates. This helps reduce manual work and keeps your table and Jira in sync.

Steps to create

Open

Creating a Cell to Jira Field Mapping

1. Open the Jira Field Mapping Dialog

   • Right-click on a specific cell in the table.

   • Select Jira Field Mapping from the context menu.

2. Configure the Mapping

   • Choose Cell to Jira Field as the mapping direction.

   • Select a target Jira field from the dropdown list.

   • (Optional) Enter a formula in the provided box if calculations are required before updating the Jira field.

3. Confirm the Mapping

   • Click Add Mapping to save the configuration.

   • The mapped cell will now update the Jira field when changes are made and saved.

Two Approaches to Writing Data

1. With Formula

• Requires users to enter a formula in the provided box when creating the Jira field mapping.

• Once a formula is applied, the input controls (such as dropdowns for select lists) are disabled because the formula dynamically overwrites the field's value.

• Useful for automating field updates based on calculated values in the spreadsheet.

2. Without Formula

For

• Users manually input values into the table cell, which are then pushed to the mapped Jira field.

• Standard input controls (such as select lists) remain available for fields that support predefined options.

• Provides flexibility for manual data entry without automation.

Sample Use Cases

Sample: Automatically Calculate and Update Estimated Cost in Jira

Setup:

• You have a table that calculates the estimated cost of a project based on different factors.

• The estimated cost should be automatically updated in a Jira custom field called "Estimated Cost" whenever the table is saved.

Steps:

1. Map a cell (e.g., C5) to the Jira "Estimated Cost" field.

2. Enter the following formula in C5:

   =B10 + (B12 * B7) + (B13 * B7)

   • B10: Base cost

   • B12: Number of hours

   • B7: Hourly rate

   • B13: Additional expenses

3. Once mapped, every time you update values in B10, B12, B7, or B13, the formula recalculates the cost, and the updated value is pushed to Jira when the table is saved.

Bonus: Using a Jira Field as Part of the Formula

• You can also use a Jira field to Cell Mapping as an input for your formula.

• Example: If Priority affects the cost (e.g., "High" priority increases the cost by 20%), you can first map the Priority field to a cell (e.g., D2), then use a formula like:

  =B10 + (B12 * B7) + (B13 * B7) + IF(D2="High", B10*0.2, 0)

  • If the priority is set to "High" in Jira, the cost increases by 20%.

  • The final calculated value is then pushed to Jira’s "Estimated Cost" field.

When Does Data Update?

• When a mapped cell is modified: Any changes made to the table cell will be queued for update.

• When the table is saved: The updated values are sent to Jira, updating the corresponding fields.

Supported Fields

• Text Field

• Number Field

• Single Select

• User Fields

• Date Fields

• Date & Time Fields