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

etenenbaum

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

Paul Newcome

Will it be on the same sheet as the data or a different sheet?

etenenbaum

Preferably on a separate sheet

Paul Newcome

Ok. Using the appropriate steps for creating cross sheet references, it is going to end up looking something like this...

=SUMIFS({Other Sheet Professional Development Time Column}, {Other Sheet Name Column}, "Andrew", {Other Sheet Date Column}, @cell = DATE(yyyy, mm, dd))

You can use cell references to cells on the same sheet as your metrics for the portion that contains "Andrew" and in place of the DATE function. If you choose to use the DATE function, you will need to update the year, month, and day numbers accordingly.

etenenbaum

Thanks Paul. Am going to be working on this tomorrow. Will let you know how it goes.