Addion of hours spent on every week

Muni Pavan Kumar Reddy Kona

Hello,

I created smartsheet for project schedule management. I put a column called "actual effort spent in hours"

Every week i would like to update this number to a report.

For example: resource enters 4 hours for week(week1)

Next week he enters 6 hours the week2 as hours spent

At end of second week, I want 10 hours in the report.

Is there any way to do?

Thanks,

Muni

MCorbin

You would either need a column for every week, which you add together.

OR

Have the user add total hours each time they update it...

OR

Have the resource enter the time in a separate sheet, linked to the task (maybe add a task ID?), and then in your project sheet, do a cross reference formula that SUMIFS where the task ID in the hours sheet matches the Task ID in the project sheet.

Muni Pavan Kumar Reddy Kona

I opt for 3 rd option, I do not want user/resource to do calculation.

what is SUMIFS syntax?