Modelled Sheets in Workday Adaptive Planning can often be difficult to troubleshoot and review underlying calculations.
Below are our tips and tricks for drilling into calculations and creating audit sheets.
How to drill into calculations
The default method of drilling into the calculations is through the Row Details menu option as shown below.
However, viewing data row by row can be tedious especially when trying to reconcile data to a specific month.
An alternative and improved method is to create an audit sheet to enhance the visibility of any modelled sheet in the Adaptive instance.
Steps for creating an Audit Sheet
Audit Sheets should generally be created as the same type of sheet (Level Assigned or User Assigned) as the underlying Modelled Sheet. In this example we are creating the audit sheet as a “User Assigned” sheet which is based off the Payroll sheet.
- Model Management -> Sheets-> User Assigned Sheets
Click “New Sheet” select “Standard” sheet as below
Input a name for the audit sheet.
Run through the standard sheet creating wizard
Add model sheet accounts to Account groups
You can add the modelled sheet account(s) by selecting one by one, or by selecting the group name to include ALL accounts in a modelled sheet.
Mark Levels available for this audit sheet (this should match the levels available to the underlying modelled sheet).
Select users and assign access to the audit sheet
Click “Save” to complete.
View the Audit Sheet
The new audit sheet created should look like the following.
Since the audit sheet in above example is created as a Standard Sheet, we can utilise the standard sheet display options to query and review the data.
For example:
- Toggle view between accounts and levels
Select an account, right click “View by Level” (at the row header section) ; or
Select a level, right click “View by Account” - Modify Display Options to select time columns
Workday Adaptive Planning Health Check Service
QMetrix provides a Health Check service to thoroughly review your instance, re-evaluate your goals and objectives, offer best practice solutions and update the Adaptive Planning solution to fit your business needs.
Related Articles
Workday Adaptive Planning Release Notes 2025: Feature Enhancements Review
Get the latest updates and highlights of each new released feature of Workday Adaptive Planning to enhance your instance.
How to create modelled sheets in Workday Adaptive Planning
Modelled sheets are tabular style sheets which let you perform data entry to drive calculations. Learn how to create a modelled sheet in Workday Adaptive Planning.
