I am trying to calculate the total revenue per month as well as the Margin % per month from our Sales Pipeline. Some of the projects run into the following month so we need to see what the revenue and margin are for each part of that time frame.

I was able to get the formula to work for the margin %


When we assign our resources with tasks, they will have a schedule looking f.ex. like this:

2016-01-01 > 2016-01-07:    10 hours:     Task 1

So sometimes during that week Resource1 has a task estimated to 10 hours. In another project (another Smartsheet sheet) he/she might have a simular task: