SI.EXPANDPROJECTESTIMATETYPERANGE
Created by Harry Lewis, Modified on Thu, 5 Dec at 1:04 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
The PROJECTESTIMATETYPERANGE function returns an Excel array showing the Project Estimate Types defined within Sage Intacct.
TABLE OF CONTENTS
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) |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article