CTC hours used by the task and role month-wise and visualize it

edited 08/11/23 in Formulas and Functions


I am trying to figure out how to calculate the CTC hours month wise used by the task and the role seperate. Is there any way to find it using formulas or widgets? Appreciate your help


  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    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?

  • alex.vellanjil

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!