This article describes how to set up a pivot report in Smartsheet based on Meisterplan allocation data.

• General
• Limits
• Report Options

General

• 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.
• Alternatively, you may use the Excel export feature of the Pivot & Charts: Allocations report to export your plan and import it in Smartsheet. This is detailed in the Setting up an Allocation Report section of the How Smartsheet and Meisterplan Work Together article and basically supports exporting the same data as with a Smartsheet report, yet with the full flexibility of the integrated Pivot & Charts reports.

Limits

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.

Report Options

• Name: name your report. Defaults to Smartsheet.
• Report Rights: select users that should have access to the report.
• Access Token: enter your Smartsheet API access token.
• Target Workspace: select the Smartsheet workspace the report should be created in. The workspace must have a folder, which you select in the next step.
• Target Folder: select the Smartsheet folder the report should be created in.
• Report Type: select the grouping hierarchy, Projects by Resource or Resources by Project.
• Unit: select the unit for working time, FTE, Days or Hours.
• Time Slice Period: select the slice period, Weeks or Months.
• Time Periods: enter the amount of weeks or months Before Today and After Today to include in the report.