SI.EXPANDSTANDARDTASKRANGE

Overview

The SI.EXPANDSTANDARDTASKRANGE function returns an array of all Standard (as opposed to project-scoped) tasks available in the Standard task catalog within the Sage Intacct Project area:

Syntax

CODE

=SI.EXPANDSTANDARDTASKRANGE(
    Connection,
    Range,
    IncludeInactive
)

Arguments

The SI.EXPANDSTANDARDTASKRANGE function uses the following arguments:

Argument	Required/Optional	Description
`Connection`	Required	The name of the connection as configured in the Connection Manager
`Range`	Optional	The range of standard tasks to include in the results. See our article on including multiple argument values
`IncludeInactive`	Optional	Boolean (`TRUE` / `FALSE`) value determining whether or not Standard Tasks marked as Inactive are included in the results. Available values: `TRUE` (Default) `FALSE`

Examples

Example 1

CODE

=SI.EXPANDSTANDARDTASKRANGE(
    "Sage"
)

Description
Returns a list of all standard (as opposed to project-scoped) tasks (cost codes).

Result

Example 2

CODE

=SI.EXPANDSTANDARDTASKRANGE(
    "Sage",
    "100:300"
)

Description
Returns all Standard Tasks within the range of 100 through 300 (inclusive).

Result

Example 3

CODE

=SI.EXPANDSTANDARDTASKRANGE(
    "Sage",
    "*;-200"
)

Description
Returns all Standard Tasks except code #200

Result

Example 4

CODE

=SI.EXPANDSTANDARDTASKRANGE(
    "Sage"
)

Description
Returns all ACTIVE Standard Tasks:

Result

(Inactive task #200 is not included)