Summary of Hours Formula


Hello SmartSheet Community,

I have SmartSheet I would like to have the total number of hours broken down by month and unit from another sheet.

Pulling from reference sheet:

Does anyone know how to get the total number of hours for all dates in January for each unit?

Also, my second complication is on the main sheet "Misc." is a category that I will need to add the total number of hours for multiple units within the January dates.


Alex Bostrom

University of Utah Health

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!