AX1573
GetCurrentSheetView function
Returns the names of the current views applied to a sheet. The function can return the sheet view, column views, and row views.
Syntax
GetCurrentSheetView("ViewType", "SheetName")
| Parameter | Description |
|---|---|
|
ViewType |
Use one of the following keywords to specify which views you want to return:
All of these items return blank if no view is currently applied. For column and row views, if multiple views are applied then the names are returned as a comma-separated list. |
|
SheetName |
The name of the sheet for which you want to return the current view names. The sheet must be configured on the Control Sheet in order to track and return currently applied views. |
All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell.
Remarks
-
This function is intended for configurations where you need to know the currently applied views for sheets that were dynamically added using the master sheets feature. However, when you are not using master sheets, then you should not use this function. Instead, you can write a formula that references the applicable Current Dynamic View field on the Control Sheet (there are two additional fields for Current Dynamic Column Views and Current Dynamic Row Views). These fields are always updated to report the currently applied views for each sheet.
- GetCurrentSheetView is a volatile function.
Examples
=GetCurrentSheetView("AppliedSheetView","Proposal")
This example returns the name of the currently applied sheet view for the Proposal sheet, such as "All Detail".
=GetCurrentSheetView("AppliedColumnView","Report")
This example returns the names of the currently applied column views for the Report sheet, such as "Q4" (if only one column view is applied) or "Q3, Q4" (if multiple column views are applied).
