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