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)