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