Connecting End Date or Duration from Jira to Smartsheet
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
Answers
-
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
I hope this helps!
Isaac J
Smartsheet Support
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!