Show Total Time Entries Per Project Task As Columns On A Saved Search

Show Total Time Entries Per Project Task As Columns On A Saved Search

 

1. Navigate to Lists>Search>Saved Searches>New.

2. Under the Criteria tab, users can set criteria to show only Project Tasks for one Project.

3. Under the Results tab, add in Formula (Numeric). On the Formula column, use the formula below:

CASE WHEN {projecttask.id} = '1' THEN {durationdecimal} END

Where XX = Project Tasks Fields...> ID

4. Enter a Custom Label and a Summary Label as required.

5. Enter a Search Title and click Save & Run.

Review the Results. Users should show one column for the total Time Entries for one Project Task.

This will show how much time was spent on each Project Task per Employee.