# Auto-update Jira data using formulas

Once you've set up your Jira to Smartsheet sync, you can access your Jira data from other sheets.

{% stepper %}
{% step %}

### Set up your sheet

First, navigate to your sheet of choice and add a column for **Jira Issue Key**.

You'll then need to populate the column with the keys you're looking to reference.

For example, you might be tracking Part Numbers that have Jira tickets associated with them:

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FMb3uNaXU8dnkY0WlFbYM%2FScreenshot%202025-02-03%20at%207.53.23%E2%80%AFPM.png?alt=media&#x26;token=b2ce2646-4d15-41d1-a10c-06f59737c246" alt="" width="563"><figcaption></figcaption></figure>

You can then use the INDEX and MATCH formulas to populate other columns.

Let's update the **Status** column according to the associated Jira key.
{% endstep %}

{% step %}

### Start an INDEX formula

In the first row of the **Status** column, type `=INDEX(` , then click **Reference Another Sheet** to select your `range`.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FAVcPndcfYKqUHQq90Wlk%2FScreenshot%202025-02-03%20at%207.31.37%E2%80%AFPM.png?alt=media&#x26;token=aeac4e9f-0eca-4450-8161-9bd31c73d86c" alt="" width="375"><figcaption></figcaption></figure>

In the popup window, find your **Jira** reference sheet, select the Jira **Key** and **Status** columns, and click **Insert Reference.**

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FhdWE1cH2InfkzxMifaWb%2FScreenshot%202025-02-03%20at%209.11.22%E2%80%AFPM.png?alt=media&#x26;token=7dc7f7c9-104c-4599-b384-0ae9e6277b7f" alt="" width="563"><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### For the row, use the MATCH formula

For the `row_index`, you'll use another formula: **MATCH**. This will identify the row in your search range that corresponds to the Jira key specified.

Type `MATCH([Jira Issue Key]@row,` to specify the search value.

Then click **Reference Another Sheet** to specify the range.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FQLzbVQyWiaHJusJRoFeX%2FScreenshot%202025-02-03%20at%209.15.47%E2%80%AFPM.png?alt=media&#x26;token=afe24320-a737-406b-8188-a4a72cc6055d" alt="" width="563"><figcaption></figcaption></figure>

In the popup window, select the same Jira **Key** and **Status** columns and select **Insert.**

Close your MATCH formula with a final parenthesis.
{% endstep %}

{% step %}

### Finish your INDEX formula

Last, specify the `column_index` of your INDEX formula: 2. This tells the formula to look in the second column of your search range for the value, which is **Status.** Close your INDEX formula, and you should see your first Status appear.&#x20;

Select the cell and drag down to populate the rest of the column.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FlkpzDjJdNOJpSPsvqOpW%2FScreenshot%202025-02-03%20at%209.34.02%E2%80%AFPM.png?alt=media&#x26;token=e1d764bf-7672-4927-94ee-2e005f89c530" alt="" width="563"><figcaption></figcaption></figure>

You're done!
{% endstep %}
{% endstepper %}