How do I calculate hours in a given week for a specific task for a specific person

Hello there


I have a sheet with the following columns:

-[Date] Type: Date

-[Name] Type: Contact List

-[Professional Development Time] Type: Text/Number (# of hours the person spent on professional development)

-[Project Related Time] Type: Text/Number (# of hours the person spent on projects)

Here's a link: https://app.smartsheet.com/b/publish?EQBCT=f31c14236ba746e5afd3319de2f6296c


Now I want to create a chart that calculates per week, the total # of hours, each contact has put towards each of these items.

Here's a visual

I'd imagine it would be using the sumifs formula but I haven't been able to figure out the syntax and how to do it.


Can anyone help?


Thanks in advance,

Sam

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!