Calculating weekly/monthly totals by dept

Elena Irvin

I am using forms for input on a calendar to track how much time is being requested of the workforce by different departments. I know what form fields I need. But I am needing to figure out how to calculate the weekly & monthly time commitment by the Request Originator. I am not sure the best way to set up my sheet to show this data or how to calculate it. This will be ongoing over the course of the year.

Heather Duff

Elena,

You may want to use a Sheet Summary for this! You can find more information about Sheet Summaries here: https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary.

You could also add some rows at the top of your sheet to add a small summary section above the data.

Either way, you could use a formula like this:

=sumif([request origination]:[request origination],"Business Acumen",[time commitment (min)]:[time commitment (min)])

Then you could use the same formula for the other departments, replacing "Business Acumen" with each department name in quotation marks.

Hope this helps!

Best,

Heather

Elena Irvin

Oh that's great!

But I will need to know ongoing weekly totals as well as monthly - how do I include those? If I put that in a sheet summary that would be at least 64 lines, that may be too busy.