SI.DEPARTMENTNAME

Overview

The SI.DEPARTMENTNAME function returns the department name corresponding to one or more given department IDs.

CODE

=SI.DEPARTMENTNAME(
    ConnectionName, 
    DepartmentId
)

The SI. DEPARTMENTNAME function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`DepartmentID`	Required	The ID number of the department

Assuming the following configuration within Sage Intacct:

CODE

=SI.DEPARTMENTNAME(
    "Sage", 
    "100"
)

Description

Returns the name of the department with the ID "100".

Result

CODE

=SI.DEPARTMENTNAME(
    "Sage", 
    C2:C4
)

Description

Returns the name of the departments whose ID numbers are listed in cell C2 through C4.

Result

CODE

=SI.DEPARTMENTNAME(
    "Sage", 
    C2#
)

Description

Returns the name of all department names whose ID numbers are displayed by the function in cell C2.

Result