SI.EXPANDPROJECTRANGE

Overview

The SI.EXPANDPROJECTRANGE function returns an array containing one or more Project IDs (based on the specified range).

Syntax

=SI.EXPANDPROJECTRANGE(ConnectionName, Project, ProjectType, IncludeInactive)

Arguments

The SI. EXPANDPROJECTRANGE function uses the following arguments:

Argument	Required/Optional	Description
ConnectionName	Required	The name of the connection as configured in the Connection Manager
ProjectRange	Optional	A range filtering specifying the projects to be displayed.
ProjectType	Optional	1 - include projects both with and without children (default) 2 - include only "parent" projects (with at least one child project) 3 - include only "leaf" projects (those without any child projects)
IncludeInactive	Optional	TRUE (default) or FALSE Determines whether or not to include entries with a Status field set to Inactive in the results. (available in version 2023.8 and higher) More info about Status

Examples

Example #1

=SI.EXPANDPROJECTRANGE("Sage")

Description
Returns the Project ID for every project in the specified connection.

Results

Example #2

=SI.EXPANDPROJECTRANGE("Sage", "IN???")

Description
Returns all Project IDs starting with "IN".

Results

Example #3

=SI.EXPANDPROJECTRANGE("Sage", "*;-100??")

Description
Returns all Project IDs that do not start with "100".

Results

Example #4

Assuming the following configuration within Sage Intacct:

=SI.EXPANDPROJECTRANGE("Sage",,2,FALSE)

Description
Returns the Project IDs for all active parent projects.

Results

The ID for the only other parent project - 10000 - is not included

About Project Statuses

Please note that Sage Intacct tracks two separate status values for each project.

• Status - for tracking whether a project is currently Active or Inactive:
  

  

and

• Project Status - for tracking additional details about the projects.
  

The IncludeInactive argument of the SI.EXPANDPROJECTRANGE function references the STATUS (active/inactive) field (not the Project Status field).