STACK.EXPANDPLANRANGE
Introduction
The STACK.EXPANDPLANRANGE function returns sorted names of plans within a given project matching the search criterion.
Syntax
=STACK.EXPANDPLANRANGE(ConnectionName, Project, Plan)
Parameters
Parameter | Required/Optional | Description |
---|---|---|
| Required | The name of the connection, as specified in the Connection Manager |
| Required | Project name. |
| Optional | A search expression for filtering plans, uses Velixo filtering techniques. If not specified, returns all plans. |
Example
=STACK.EXPANDPLANRANGE("Stack", "Second Project")
Description: Returns all plans in the Second Project
project for the connection named Stack
.
Result:
