Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

JIRA Integration: converting JIRA estimates into Smartsheet duration

Andy C.
Andy C.
edited 12/09/19 in Archived 2017 Posts

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.



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,



  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 02/01/17

    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
    Zack S Employee

    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. 



  • 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.

This discussion has been closed.