CTC hours used by the task and role month-wise and visualize it
Options
Answers
-
This is definitely something that can be done, but I am not sure there is enough information here to do it accurately. All of your sub-tasks span multiple months. Do you have the CTC hours broken down month-by-month for each of those, or would you rather average the hours based on the number of months of that task?
-
I don't have a month by month break down for CTC. But Averaging the hours based on the number of months of that task or averaging the hours based on number of months by specific role wise will also help.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!