Hi I'm wanting to use SS more in how we do resource planning. One thing which is quite painful is the output from the export on the resource view.
What would be easier as a complimentary tab on the excel export is a more "Pivot table usable" output, for the same range so something like
Date Project Resource Allocation
this would then allow the data to be managed more easily in Excel. The output you provide is very simlar to this but not standardised, as it has been melded into a cross between data and report.
I've attempted to do this through the reports view, however Reports can only show start and stop dates, not the allocation per day on a range of dates.
I'm working with macros to try and reprocess the exisiting format, but that is somewhat challenging! If anyone has written some good macros for processing the Smartsheet resource outputs, are you willing to share?
Cheers, Ken