Sum of hours worked by employee for current week and previous week using weeknumber

Hi All,


I am spinning my wheels trying to get this formula figured out. Caveat is I'm a fairly new Smartsheet user.

Essentially I am using a request tracker sheet to document and drive a dash where I want to show the amount of time each employee spent per task week over week. I'm using week numbers and on my metrics sheet I am trying to write a formula to show this. Screen grabs show my sheets and current formula, which returns zero.

Goals:

Sum hours worked by person for current week.

Sum hours worked by person previous week.

Create line chart in dash that shows week over week by person.


I'm not sure how to go about this and correct the formula I have. Maybe my approach is all wrong too. Any help and advice would be greatly appreciated!


Thanks,

Scott


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!