Addion of hours spent on every week

Options

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

Answers

  • MCorbin
    MCorbin Overachievers Alumni
    Options

    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.

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

    what is SUMIFS syntax?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!