Any scripts/shareware to convert resourse reports to FTE/Labor Cost reports

djpreece · 08/07/18

Hi all,

I've been exporting resource reports into Excel, then manually formatting/adding equations/creating pivots then importing back into Smartsheet to get the labor cost reports (FTE/person months/allocation etc) for a project.

It's fairly straight forward but was wondering if anyone has optimized such a process.

Also, Smartsheet reports allocation per sheet...would be nice to isolate a set of tasks (within in sheet) and run a allocation report on the subset

Any thoughts/guidance greatly appreciated!

Darrell

Shaine Greenwood · 08/10/18

Hi Darrell,

You might consider checking out our Pivot premium app to reduce having to export to excel, pivot, then import as a new sheet: https://help.smartsheet.com/articles/2476736-get-started-pivot

There currently isn't a way to show allocation on a specific set of tasks, only on the resource and/or project. More on resource management in Smartsheet is available here: https://help.smartsheet.com/articles/1346969-resource-management-allocation-team-enterprise-only-

Any scripts/shareware to convert resourse reports to FTE/Labor Cost reports

Comments

Categories