Skip to main content
Skip table of contents

SI.EXPANDPROJECTESTIMATETYPERANGE

Overview

The PROJECTESTIMATETYPERANGE function returns an Excel array showing the Project Estimate Types defined within Sage Intacct.

Syntax

CODE
=EXPANDPROJECTESTIMATETYPERANGE(ConnectionName, Range)

Arguments

The EXPANDPROJECTESTIMATETYPERANGE function uses the following arguments:

Argument

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

A named range ("Connection") has been used for the ConnectionName argument in these examples

Example - All estimate types

CODE
=EXPANDPROJECTESTIMATETYPERANGE(Connection)

Description

Returns all project estimate types defined in the specified connection

Result


Example - Estimate types starting with specific characters

CODE
=EXPANDPROJECTESTIMATETYPERANGE(Connection,"Cur?")

Description

Returns all project estimate types starting with the letters CUR

Result


Example - Exclude one or more types from the list

CODE
=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)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.