Resource Forecasting formula

Dear all,

I hope someone can help me; I have a large sheet with a row per resource and a set of 4 columns repeating for each week of the year. The first column of the 4 has a week commencing date; this is dynamic based on a start date I enter into a reference cell. The second column in the repeating columns derives the month and year from the week commencing date. The following two columns have the planned hours and the actual hours.

The columns repeat to allow for 52 weeks.

The help I need is if there is a formula that will allow me to capture the total hours planned per month from the original sheet on a summary sheet per resource. I have replicated the resources in the first column of the summary sheet and added the month and year to the 1st row on the summary sheet.

I appreciate that this may be a big ask, but any support would be appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!