sum hours assigned to a contact on a sheet for a particular month

Options
tlawrence17
tlawrence17 ✭✭
edited 12/09/19 in Formulas and Functions

Example: I have a project that lasts three months on a project sheet. 

I am required by the client to report out how many hours of work have been completed by each person assigned to a task at the end of each month on a dashboard

So for example: I need a formula that is going to Find all columns assigned to the contact "Timothy Lawrence" in August (Finish date column) and total those hours

Here is where I am getting stuck...

=SUMIF(Resource:Resource, FIND("Timothy Lawrence", @cell) > 0, [Actual Hours]:[Actual Hours])

This finds all of the hours worked by Timothy Lawrence on the sheet, however I can't seem to figure out how to narrow it down by the month.

The way I logic it out in my head is: "Sumif resource is Timothy Lawrence and finish date is month 8"

I have tried the formula below but get an Invalid data type:

 =SUMIF(MONTH(8), AND(Resource:Resource, FIND("Timothy Lawrence", @cell) > 0, [Actual Hours]:[Actual Hours])) 

Any thoughts? I'm stuck using the sheet template provided by the client (just adding formula rows to the bottom) so an actual re-write of the sheet isn't possible.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!