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