Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

edited 08/11/23 in Formulas and Functions

Hi,

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

Answers

  • Community Champion

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions