Jira Connector Stale Data

hctauto

Hi,

We primarily work from Jira but tend to use smartsheet for easier bulk changes and workload overview. The problem we frequently run into is that the smartsheet side tends to have stale information that may or not resolve itself when a ticket is updated. Our most recent examples are:

1) Issues that fall out of the scope of a Jira Connector sync workflow do not get moved under the "Filtered Out by Connector" label so we have two tickets referencing two different sheets assigned to two different users but pointing to the same Jira ticket. Updating the ticket from the jira side updates the valid entry in smartsheets but the stale entry remained as is until we manually deleted it.

2) If we update a single-picker field in Jira to have more options, the additional choices are not pulled into smartsheets. This means that we are stuck manually modifying the column properties on every smartsheet that references that field before we can sync new changes back to Jira.

Is there anything we can do to resolve this?

Genevieve P.

Hi @hctauto

For your first issue, it's difficult to know what's going on here without seeing your full set-up. I would suggest contacting Smartsheet Support with a screen recording showing your Smartsheet sheets, the workflow configuration, and your set-up in Jira so they can identify if what you're experiencing is expected or not. (Here's more information on what's expected with the "Filtered Out By Connector").

In regards to changing pick-list values, the mapped column in Smartsheet will not be updated automatically as you've found.

You can manually adjust the column properties in Smartsheet, or you can use the following steps:

1. Edit the Jira Connector Workflow and remove the picklist field in Field Mappings in the "Fields" section
2. Re-add the the picklist field with the (new column) option and save the workflow

The new column will include the updated picklist values, and the old column can be deleted.

Please let the Product team know of your feedback on the Jira Connector by using this form, here.

Thanks!

Genevieve