Expand my Community achievements bar.

Automatically populate Task % Complete and Project percent complete based on the Actual Hours logged compared to the Planned Hours for this Task!!

Avatar

Level 2

1/26/24

Description - in a project, I would like % Complete column to automatically be calculated based on the actual hours entered by the user.

Why is this feature important to you - This will help the project managers to log only the actual hours and not assume the percentage.  The percent value should automatically be calculated based on the project manager's logged Actual hours vs their planned hours on a task.

How would you like the feature to work - I would like the % column to automatically be calculated based on the actual hours entered by the user. Also, I would like this percentage to be rolled over to the project level.

Current Behavior - In a project, the project managers estimate a percent complete and enter into the % complete column resulting in a number that may or may not be accurate. 

A Work Around Solution that I created: I created a view. In the view I added the Actual Hours column and a Task Percent complete column.  In the view, I now have the following columns: task name, duration, planned hours, Task Actual Hours, Task % complete, Actual completion date, Project % complete columns.  When, the project manager logged in the actual hours, the task % complete column automatically calculated the %.  But the Project % complete column still had to be manually updated with that calculated % value.  We needed the Project % complete column because that was the value that would be rolled over to Project % complete value in the header of the project.