Connecting End Date or Duration from Jira to Smartsheet

Gina Prego

I understand that I cannot bring over the end date from Jira to Smartsheet when there is dependencies/ one directional. Does anyone have a tip to use a duration field in Jira to populate the end date in Smartsheet? Or any other way to get an end date in Smartsheet from Jira? I have dependencies enabled in Smartsheet and I need them

Isaac Jose

Hello Gina,

Thanks for your post! Please feel free to submit an enhancement request here: https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409

As an immediate workaround, your best option is to insert additional columns that are not mapped to the project settings or dependencies. You'll have columns for Start Date, End Date, Duration, Jira Duration, and Jira End Date. On the Jira Duration and Jira End Date columns will be mapped with the Connector, and the rest will be managed manually or through the project settings.

Perhaps you can also insert a sixth column with a formula to calculate the date variance between the End Date and Jira End Date from which a filter and/or automated alert can be built so that you can easily correct any rows with date variance.

Here are some related articles

https://help.smartsheet.com/articles/2476121-jira-workflows

https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors

https://help.smartsheet.com/function/networkdays

I hope this helps!

Isaac J

Smartsheet Support

THUNT6

This is an old thread but would like to see if there has been any improvement on this topic.

I am trying to sync a duration field from JIRA directly into the duration column in smartsheet and then have smartsheet return the start and finish dates to JIRA based on the dependencies without having to manually copy and paste values from one column to another each time it syncs.