SI.EXPANDPROJECTESTIMATETYPERANGE
Overview
The PROJECTESTIMATETYPERANGE function returns an Excel array showing the Project Estimate Types defined within Sage Intacct.
Syntax
=EXPANDPROJECTESTIMATETYPERANGE(
ConnectionName,
Range
)Arguments
The EXPANDPROJECTESTIMATETYPERANGE function uses the following arguments:
Argument | Required/ Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Optional | A range filter specifying the Estimate Types to be displayed |
Examples
A named range ("Connection") has been used for the ConnectionName argument in these examples
Example - All estimate types
=EXPANDPROJECTESTIMATETYPERANGE(
Connection
)Description
Returns all project estimate types defined in the specified connection
Result
Example - Estimate types starting with specific characters
=EXPANDPROJECTESTIMATETYPERANGE(
Connection,
"Cur?"
)Description
Returns all project estimate types starting with the letters CUR
Result
Example - Exclude one or more types from the list
=EXPANDPROJECTESTIMATETYPERANGE(
Connection,
"*;-draft;-backlog"
)Description
Returns all project estimate types except Draft and Backlog
Result
(a cell reference has been used for the Range argument in this example)