Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!
SOLVED

Billable Actual Hours

Avatar

Level 1

Hi there,

 

I am looking for guidance on how to create a custom field (that will be displayed as a column like in the attached mock-up) that mimics all the features of the Actual Hours field/column such as summing up hours against single tasks and also rolling up to the parent task(s) but it is a sub-set of Actual Hours as it will only take into considerations hours with hour type = Task time.

 

Thank you,

Andy

1 Accepted Solution

Avatar

Correct answer by
Level 10

hi @AndyConsolini 

1) Create a calculated field name "Billable Hours", follow below;

Kundanism_0-1685531428113.png

Kundanism_2-1685531603502.png

 

2) Go to task level, attach custom form to the specific task or all task.

3) GO to view and recall calculated field as shown below;

Kundanism_3-1685531615038.png

 

 

View solution in original post

3 Replies

Avatar

Level 10

Hi @AndyConsolini  Is Billable Actual Hours is the same as Actual Hours per task?

Avatar

Correct answer by
Level 10

hi @AndyConsolini 

1) Create a calculated field name "Billable Hours", follow below;

Kundanism_0-1685531428113.png

Kundanism_2-1685531603502.png

 

2) Go to task level, attach custom form to the specific task or all task.

3) GO to view and recall calculated field as shown below;

Kundanism_3-1685531615038.png

 

 

Avatar

Level 1

Billable Actual Hours is only Actual Hours wiht Hour type = Task Time per task