How to estimate hours per Task using % allocation, Assigned to and Duration Columns?
I hope you all are doing alright.
We need to estimate how many hours will problaby be spent on each task. We already use %allocation, Assigned to and Duration columns in our cronograms. We can't use the suggested formula "%allocation * Duration * 8" because:
1) Multiple employees can be assigned on the same task. I have no idea how Smartsheet can "break" the cell to read which employees are assigned to the task.
2) Not all of our employees are full-time, we also have part-time and interns assigned in our projects, so the number of hours worked per day may vary according to the Employee. We already have a sheet that contains the employees names and hours worked per day.
Do you know how can I calculate it using Smartsheet?
Thank you and have a great week!