Workload over Calendar Duration

Jamison Sills

I am very new to Smartsheets and am in process of educating myself on the product to help develop some staffing workload tools on a project basis over time.  The goal is to help us analyze how employees are allocated on a project over a calender timeline. 

For example, we use project milestone deadlines to break up a project progress and divide the associated revenue for that milestone with a billable rate and then across a duration:

i.e. 4 week Schematic Design milestone: $15,000 total revenue / $150 per hour = 100 hours = 25 hours per week workload for employee A.

Is there a way to create a sheet that records the milestone workload (I can handle the simple formulas of $15,000 / $150 per hour = 100 hours) but I need help with how to take the 100 hours  and have it distributed over a duration.  And the real win would be to have that duration associated with actual calendar dates so that we can plot the load over a calendar for the employer, project, firm, etc.

Any help would be awesome.  I have been looking through templates and community topics and haven't been able to shed any light on if this is possible.    

Alejandra

Hi Jamison,

When dependencies are enabled on your sheet, inputting a start and end date will automatically populate the duration column. However, when dependencies are enabled, project columns (like duration) do not support formulas.

If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#Duration

I think this would be a great opportunity to submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.