Hey Guys,

I started to use the JIRA connector for Smartsheet and run into some basic issues while creating the workflow.

Idea here is I want to create the Jira tickets (Epic, Story, Sub-tasks, Bugs) from Smartsheet but need 2-way sync to keep updated everything on both the places.

Query 1: during


I am trying to get a summary of duration for a particular resource within a particular month in smartsheet. This is unfortunately so that I can then input the hours into a custom ERP that lacks any intuitiveness. How could I do this? 

Here is an example


Resource .  Duration . Start Dates, End

Rc Contractors


I post a problem 2 days ago 

some response but still doesn t work, new to smartsheet but my work is blocke now



Hello @Craig and other Helpers

i experiment the same issue than other

sorry for my english but i m french

i copy your formula below and try to adapt with "laserjet" type

i want to


I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks?


Thank you,

- Blake