Change Existing Reports
- An existing Google Sheets report with Adaptive Planning data.
- Security:Access to Workday for Google Sheetspermission
To update existing reports, you can rearrange the reporting elements in the report builder. You can move element groups and element types to rearrange them:
- Across rows, columns, or filters.
- Within rows, columns, or filters.
You can also duplicate existing reports to create new ones by copying a sheet to a new sheet in the same workbook. The new report includes all the elements and metadata from the exiting report including:
- Expand states of elements
- Managed hierarchies
- Relative times
- Adaptive planning instance
- Open an existing Google Sheets report or create one.
- From the Google Sheets toolbar, click . The Workday add-on displays.
- In the Report Builder, select the element type for the element group that you want to rearrange.Example: To move levels from theFiltersarea to theRows, selectLevels.
- Click and drag using the handle that displays to the left of the element type. The entire element group for the element type moves to the new location.Example: You can drag and move the Levels element type and its groups of level elements from the Filters to the Rows.
- (Optional) Rearrange the element group above or below other existing items in the report.
- Refresh the report to see the latest changes in the spreadsheet.