Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Sheets Interface Tour

Introduces you to the interface of the Sheets Overview page, the Assumptions Sheets Overview page and an open sheet.

Contains preview content for the upcoming 2019.3 release.

See Using Sheets to see all the articles.

Watch this video: (1m 7s)

Meet the Sheets
 

Sheets Overview Menu

From the nav menu, select Sheets or Sheets > Overview.

The Sheets Overview screen

1 All sheets assigned to levels you can access. 

2 Version drop-down: All versions you can access. 

3 Level drop-down: All levels you can access. 

4 Search for all cell notes throughout all sheets assigned to your levels or create an Audit Trail report. Additional permissions required.

5 View or change the Workflow status  (if you have Workflow). 

Assumptions Sheets Overview

From the nav menu, select Assumptions or Assumptions > Overview.

User assigned sheets overview screen

1 All sheets assigned directly to you.

2 Version drop-down: All versions you can access. 

3 Search for all cell notes throughout all sheets assigned to you or create an Audit Trail report. Additional permissions required.

4 Select sheets to push through the Workflow process (if you have Workflow).

5 Review workflow status and notes (if you have Workflow). 

Individual Sheets

Once you open a sheet: 

Opened Sheet interface

1 The sheet toolbar: Complete tasks with buttons. The toolbar changes for each sheet type.

2 Version drop-down: All versions you can access. 

3 Level/Account drop-down: All levels you can access or accounts on the sheet. 

4 Formula bar: Enter data or formulas and click the green checkmark. Click the red x to delete data.

5 Row and column headers: Most sheets have accounts listed down the first column and time listed across the first row. Expand and collapse hierarchical rows and drag column dividers to resize them. See Change Sheet View.

6 Cells: Enter data directly into cells or right-click for additional actions.

7 Currency: If your model has different currencies per level, select a cell and then check here to see the currency used.

8 Keyboard Shortcuts: View a list of keyboard shortcuts.

  • Was this article helpful?