The Time it Took to Perform a Particular Action

Hi,

I realize the questions is quite vague, but is there any way to show/calculate (this need not necessarily be done via a Report as the word is used in Smartsheet terminology) the time it took for somebody to complete a certain action.

I,e. let's say there's a task that somebody is assigned to and they begin this task by ticking a checkbox and then complete the task by clicking another checkbox.

Any and all suggestions are greatly appreciated!

Find more posts tagged with

Sheets

Formulas

Reports

Conditional Formatting

Comments

Kennedy Stomps

Hi Piotr-- It isn't currently possible to track this directly in Smartsheet, since we don't offer the ability to "capture time" conditionally. I've added your vote for this to our enhancement request list!

I know some customers use our integration with Harvest to accomplish this at this time. Let me know if you run into any trouble with this, should you decide to take this route!

Galen Dalrymple

Kennedy: the problem with the Harvest integration is that it is outbound from Smartsheet to Harvest. We use Harvest to track time spent on tasks (and it does a great job of that), but would love to have the data from Harvest import into Smartsheet to populate time actually spent on tasks.

Is there some way to do that? Outbound doesn't really help us in calculating how much time we spent (and therefore money) on tasks/projects. As it is, we have to manually key Actual time spent into Smartsheet cells to get that kind of information.