Jira connector - Duration update in Jira does not update back the end date in Jira

Options

Hello,

We use the Jira connector to sync a sheet and a Jira project. The workflow is configured as follow:

Start date: Unidirectional Smartsheet -> Jira

End date: Unidirectional Smartsheet -> Jira

Duration: Bidirectional Smartsheet <-> Jira

The idea is to let Smartsheet drive tasks start and end dates but allow Jira users to change a task's duration.

The issue we have is that when we update a task duration in Jira it updates the duration and end date fields in Smartsheet but this end date field's new value is not synced back to Jira. Basically I have this case:

Jira duration update -> Smartsheet duration field is updated -> Smartsheet end date field is updated -> Jira issue end date field is not updated

If I update the sheet manually to update the duration and save, the sync to Jira works fine, e.g. duration and end date are synced in Jira properly, which tells me my workflow is working fine but it seems to fail to sync back to Jira the updates generated by a Jira->Smartsheet sync.

Is there a solution to this issue in order to keep the start and end dates in sync in between Jira and Smartsheet?

Thanks in advance,

David

Answers

  • Julio S.
    Julio S. Moderator
    Options

    Hi @DDupuis,

    Due to the special nature of the dependencies functionality in Smartsheet, there are certain restrictions applying here. It appears that you may have mapped the End Column of your project prior to enabling this functionality. If you would start the connection anew and leave dependencies on, you'll see that the connected End date Column wouldn't be available for mapping. In this older post you can see more information about these particular restrictions.

    At the moment, the only alternative that I can recommend would be to use parallel columns that aren't used in dependencies but this would cause for the automatic calculations with duration not to occur with those Columns and you may need to periodically manually adjust this or use an alternate method.

    When you have a moment, please submit your feature request to the Product team by signing in to the online Community (the Community uses your Smartsheet account to sign in) and create an Idea post in the Smartsheet Product Feedback and Ideas topic

    Posting your enhancement in the Community will allow other Smartsheet users to see and vote on your idea! The top-voted posts in this category are reviewed monthly by the Product team and you'll receive an email notification if a status changes for a post you've created or voted on. 

    I hope this can be of help.

    Cheers!

    Julio