/
Timesheets by Tempo

This article is for Cloud. Visit Data Center

Timesheets by Tempo

Timesheets by Tempo is the #1 time tracking app for Jira, providing teams with simplified and automated time tracking, accurate financial reporting, and the ability to log billable service hours.

The integration between Structure and Timesheets allows you to:

  • Add Tempo Logged Time data as columns in your structure, and aggregate that data across your hierarchy

  • Use billable time and worklog data in formulas

  • Organize your structure data based on Tempo accounts and Tempo teams

Structure with Tempo Work Logged columns

Don't have Timesheets? Try it for free!

Adding a Tempo Logged Time Column

Adding a custom Tempo Logged Time column to a structure allows you to easily track work time and billable hours alongside your project data, and aggregate those values up your hierarchy.

Using Timesheets Data in Formulas

You can use Tempo Logged Time (tempoLoggedTime) and Tempo Billable Time (tempoBillableTime) within a formula to do calculations or comparisons based on your time tracking data.

In the example above, we switched the formula’s Format to Duration. Otherwise, time values will be displayed in milliseconds.

Customizing Tempo Time Tracking Values

The values for the Tempo variables are the same as you would see in the Tempo Logged Time column with the following options selected:

  • Period = All Time

  • Users = All

  • Billable time option is selected

To customize these options, select the variable and adjust its settings:

Using Worklog Properties in Formulas

You can also use the following Tempo worklog properties within a formula:

  • author

  • created

  • updated

  • comment

  • startData

  • started

  • timeSpent

  • billable

  • id

To use Tempo logged time properties in a formula, use the following format: tempoWorkLogs.author

Learn more: Item Properties

Using Tempo Work Attributes in Formulas

If you’ve created custom Tempo Work Attributes, these values can also be used in formulas: tempoworklogs.<WORKATTRIBUTEKEY> (Replace “<WORKATTRIBUTEKEY>” with the key for the work attribute you want to use.)

If you don’t know a work attribute’s key, create a column with the formula FLATTEN(tempoworklogs.workattributekeys)- this will provide a list of available work attribute keys.

 

Related content

Tempo Logged Time Column
Tempo Logged Time Column
More like this
Timesheets by Tempo
Timesheets by Tempo
More like this