In project management, users check the actual time, planned time and the approved time entries logged against a project task for reporting and reconciliation:
Instead of users checking the projects and project tasks one by one, they can instead create a saved search to view all project tasks with these columns. Here’s how:
1.) Navigate to Lists > Search > Saved Searches
2.) Select Project Tasks
3.) Under Results tab:
Sort by: Project
Then by: Name
4.) In Columns subtab of the Results tab remove all and add the following:
Field: Project | Summary Type: Group
Field: Name | Summary Type: Group
Field: Planned Work | Summary Type: Group
Field: Actual Work | Summary Type: Group
Field: Formula (Numeric) | Summary Type: Sum | Formula: CASE WHEN {time.approvalstatus} = 'Approved' AND {time.type} = 'Actual Time' THEN {time.durationdecimal} ELSE 0 END | Custom Label: Approved Time
5.) Rename Saved Search and Save & Run
Results:
For example, a Project Task with 10 planned hours, an actual time of 10 hours and an approved actual time of 8 hours is displayed in a report as follows:
Source Task:
With this Saved Search, users can easily check the time/hours related to projects and project tasks in one page instead of going through the project records one by one. Users can check for example the Actual Time vs the Approve time for each project task and compare it to the Planned Work/Time at the same time.
Have you tried this saved search or a similar one before? Please feel free to share your tips below.
I hope this helps 🙂