Calculating resource allocation for week or month view

B.Germain ✭✭
edited 12/09/19 in Smartsheet Basics

As the resource view in resource management is only viewable by licensed users, and is in days, I'm interested to hear from other users how they were able to export data to excel and calculate for a week or month view.  I've tried to export to excel but only see the grid info, no allocation % applied to dates (resource view).  Has anyone figured out how to provide their leaders a week or month view into resource allocation?

I know SS has acquired 10,000ft, but I have an immediately need (and know 10,000 will also be additional cost).  I'd like to see how to maximize the current function. 

If you have an example excel template please share.