JIRA Integration: converting JIRA estimates into Smartsheet duration

Hi Smartsheet Community,

We've integrated JIRA into Smartsheet. Our goal is to use Smartsheet to view the high-level roadmap of a project, based on summing the estimates of all tickets in JIRA.

In JIRA, our tickets are estimated in hours. When the workflow is synced via the "Original Time Estimate" field, they somehow convert to minutes in Smartsheet.

Questions:
1) Is there any way to display the [Duration] on Smartsheet to be in hours, rather than days?

2) If not, is there a way to configure the [Duration] field to accept a function from the Original Time Estimate, with the below formula?

Duration = (Original Time Estimate) / (1d), where:

* 1 day = 60 min * 8 hrs

* Original Time Estimate = JIRA estimates in minutes

Example: The assignee of the JIRA ticket estimates "Ticket A" to take 40h to complete. In smartsheet, that ticket duration is calculated at:

Duration = (40h*60m) / (60m*8h) = 5 days.

Thank you,

Andy

Find more posts tagged with

Formulas

Integrations

Project Management

Comments

Shaine Greenwood

Hi Andy,

There isn't a way to set a default duration (such as, only display duration in hours) but I've got your vote down for this on our enhancement request for further consideration.

With that being said, you might be able to accomplish this by placing a formula in another column that takes the duration and sorts it into hours. Details on formulas can be found in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas

Zack S

Hi Andy,

Along with Shaine logging a vote for the app itself to change the default of the duration column, I’m also logging this vote specifically with the developer team in charge of the connector app. We’ve had several requests for this and we would like to see if it’s possible to make a change specifically in the connector (possibly making a conversion). So your vote has been logged both in the main app’s enhancement request list, as well as our Jira connector request list.

With the connector using the API there are certain limitations that we need to work around, so we can’t confirm if or when this feature will be available, but we know it’s a pain point and is definitely something we are looking into.

-Zack

Andy C.

Thanks Shaine and Zack, appreciate the follow up here. Glad to hear this is a common pain point and look forward to seeing an enhancement in the future.