SI.DEPARTMENTNAME
Created by Damien Zwillinger, Modified on Thu, 14 Sep, 2023 at 2:22 AM by Damien Zwillinger
Applies to:
- Velixo NX
- Sage Intacct
The SI.DEPARTMENTNAME function returns the department name corresponding to one or more given department IDs.
TABLE OF CONTENTS
Syntax
SI.DEPARTMENTNAME(Connection, DEPARTMENTID)
Parameters
The SI. DEPARTMENTNAME function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
DepartmentID | Required | The ID number of the department |
Examples
Assuming the following configuration within Sage Intacct:
Example 1
=SI.DEPARTMENTNAME("Sage", "100")Description
Returns the name of the department with the ID "100".
Result
Example 2
=SI.DEPARTMENTNAME("Sage", C2:C4)Description
Returns the name of the departments whose ID numbers are listed in cell C2 through C4.
Result
Example 3
=SI.DEPARTMENTNAME("Sage", C2#)Description
Returns the name of all department names whose ID numbers are displayed by the function in cell C2.
Result
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