Formula For Summing Workload by Assignee by Week
Hi Smartsheet pros - I'm hoping to find a formula that can tally hours worked per person by week # across different projects. It'd be something like if the Week # falls within the Start and End Week of a project and its assigned to a certain person, sum Hours/Week. The results for Tori for Week 1, as an example, should be 15 since she's working on both Projects A and B during Week 1.
I am super stumped by this one and would love any suggestions you may have.
Help Article Resources
Check out the Formula Handbook template!