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:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/lTfoupVHUMo9bQg9tkdjdxEwvT_AStZMyA.png

Syntax

=SI.EXPANDSTANDARDTASKRANGE(
    ConnectionName,
    Range,
    IncludeInactive
)

Arguments

The SI.EXPANDSTANDARDTASKRANGE function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`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

=SI.EXPANDSTANDARDTASKRANGE(
    "Sage"
)

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

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/EsmkgWNCz001Yxx-xP1H28Fzm53Yc1muwQ.png

Example 2

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

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

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/2jgCLxG9A5Lewsc3ZwXFWRT4UG_dvmxgog.png

Example 3

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

Description
Returns all Standard Tasks except code #200

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/CV1U6braRmvwpeEZyfp0mMGwxthHc3MMpw.png

Example 4

=SI.EXPANDSTANDARDTASKRANGE(
    "Sage"
)

Description
Returns all ACTIVE Standard Tasks:

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/6PFWpYoiZNcASkUzuUqfYNVpwX2PGeK5zA.png

(Inactive task #200 is not included)