STACK.EXPANDPROJECTRANGE

Overview

The STACK.EXPANDPROJECTRANGE function returns sorted names of projects matching the search criterion.

Syntax

CODE

=STACK.EXPANDPROJECTRANGE(
  ConnectionName, 
  Project,
  BidDateFrom,
  BidDateTo,
  CreationDateFrom,
  CreationDateTo,
  Status
)

Arguments

Argument	Required / Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Project`	Optional	A search expression for filtering projects, uses Velixo filtering techniques. If not specified, returns all projects.
`BidDateFrom`	Optional	Earliest bid date.
`BidDateTo`	Optional	Latest bid date.
`CreationDateFrom`	Optional	Earliest project creation date.
`CreationDateTo`	Optional	Latest project creation date.
`Status`	Optional	A search expression for filtering project statuses, uses Velixo filtering techniques. If not specified, returns all statuses. Use the STACK.EXPANDPROJECTSTATUSRANGE function to list all available statuses.

In case of discrepancies between projects returned by the function and data in STACK, we recommend performing a Full Refresh (Refresh → Full Refresh (Slow) in the Velixo NX Excel menu).

Example

CODE

=STACK.EXPANDPROJECTRANGE(
    "Stack",
    ,
    ,
    "2025-01-01"
)

Description: Returns all projects created after 1st Jan 2025 for the connection named Stack.