Document toolboxDocument toolbox

Create Timesheet gadget on Projectrak Cloud

Owned by Laura Barreales Rubio, created
Oct 24, 2024
2 min read

Hosting

CLOUD

Problem

On Projectrak Cloud you won’t find Timesheet gadget, but you can achieve exactly the same with a few steps.

We've launched the feature that allows you to operate with project fields, and then you can get in the Project Navigator all the information you've seen on the Timesheet gadget of Projectrak in Data Center:

image-20241024-063858.png

 

Steps

5 fields

Estimated time

A duration type field, already created by Projectrak

Time spent

Create a new formula field

image-20241024-065808.png

Time spent %

Create a new formula field

To build the expression, introduce the ID of the fields: you can find the IDs on the Projectrak fields manager.

You need the ID of Estimated time and Time spent.

To get hours, we are dividing our values by 3600 (the number of seconds per hour)

Remaining

Create a new formula field

Remaining %

Create a new formula field.

To build the expression, introduce the ID of the fields: you can find the IDs on the Projectrak fields manager.

You need the ID of Time spent %.

Add a Project List gadget to a Jira Dashboard

Include all the previous fields

Paste on Confluence page de Dashboard URL

This is the result:

 





Related articles