With the TrackingTime Button you and your team can track time spent on projects and tasks right within Smartsheet. It's as easy as adding a formula in a cell and then clicking play!

Formula to track a task

The following formula in the cell where you'd like to display the tracking button. 

="TrackingTime:"+[select the cell for your task]

Formula to track a project task

In case you'd also like to specify the task's project, you need to use the following formula to specify which cell contains the project name.

="TrackingTime:"+[select the cell for your task]+",,"+[select the cell for your project]

Step by Step Guide

Here's a step by step guide on how to start tracking your time in Smartsheet.

  1. Download and install the TrackingTime Button for Chrome.
  2. Once installed, click on the extension icon and enter your email and password to log into your TrackingTime account. If you don't have a TrackingTime account yet, you can signup for free.
  3. Go to Smartsheet and open the sheet you'd like to use for time tracking.
  4. Select the cell where you want the tracking button to appear.
  5. Enter the following formula:
     and select the cell which contains the name of the task you want to track.

That's it. Now, you can start tracking your time by clicking on the button you've just added to your Smartsheet.

Smart Task Selection

Your tasks and projects in Smartsheet will be automatically synced with your TrackingTime account. We'll look in your TrackingTime account for a task with the name displayed on the cell you selected. If it doesn't exist yet, we'll automatically create it. Similarly, if the project you specified doesn't exist yet, we'll automatically add it and assign the task to it.

Did this answer your question?