This article describes how to set up a pivot report in Smartsheet based on Meisterplan allocation data.
Create a Smartsheet report in the report manager to create a pivot report based on Meisterplan allocation data in Smartsheet. When this report is invoked in Meisterplan, it will be generated and opened in Smartsheet.
Please note that the maximum amount of data that can be passed to Smartsheet this way is limited to 5000 lines of data. The required number of lines depends on the selected Report Type and the amount of projects, resources and allocations to import:
- With the Projects by Resource setting, one line will be required per resource and an additional line will be required for each project a resource is allocated to.
- With the Resources by Project setting, one line will be required per project and an additional line will be required per allocated resource for each project.